fdefd

SELECT co.Name AS "Kraj", COUNT(ci.Name) AS "Liczba miast" FROM city ci, country co WHERE ci.CountryCode = co.Code AND co.Continent="Europe" AND ci.Population > 300000 GROUP BY co.Name ORDER BY co.Name;