Advertisement
Guest User

Untitled

a guest
Oct 21st, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.27 KB | None | 0 0
  1. SELECT cont.ContinentName,
  2.     SUM(c.AreaInSqKm) AS CountriesArea,
  3.     SUM(CAST(c.Population AS FLOAT)) AS CountriesPopulation
  4.     FROM Continents AS cont
  5. LEFT JOIN Countries AS c
  6.     ON c.ContinentCode = cont.ContinentCode
  7. GROUP BY cont.ContinentName
  8. ORDER BY CountriesPopulation DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement