Functions-Triggers ... Exercises: Problem 31. Population and Area by Continent
Ето ми е заявката - РАБОТИ !
SELECT con.continent_name,
SUM(c.are_in_sq_km) AS countries_area,
SUM(c.population) AS countries_population
FROM continents AS con
INNER JOIN countries AS c
ON c.continent_code = con.continent_code
GROUP BY con.continent_name
ORDER BY countries_population DESC;
Но в judge ...
A compile time error occurred.
Unknown column 'c.are_in_sq_km' in 'field list'
Проверих базата, таблицата си е кръстена точно така 'are_in_sq_km' ?