Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cont.ContinentName,
- SUM(c.AreaInSqKm) AS CountriesArea,
- SUM(CAST(c.Population AS FLOAT)) AS CountriesPopulation
- FROM Continents AS cont
- LEFT JOIN Countries AS c
- ON c.ContinentCode = cont.ContinentCode
- GROUP BY cont.ContinentName
- ORDER BY CountriesPopulation DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement