Average Population of Each Continent EasySQL (Basic) – HackerRank Solution SQL, Best and Optimal Solutions , All you need.
Solutions of SQL all HackerRank:
Here are all the Solutions of All of SQL of Hacker Rank , Leave a comment for similar posts
SQL Average Population of Each Continent EasySQL (Basic) HackerRank Solution
select
co.continent, trunc(avg(ci.population))
from
city ci
join country co on (co.code = ci.countrycode)
group by
co.continent
;
SQL (Basic)
SQL (Intermediate)
SQL (Advanced)
Basic Select
Advanced Select
Aggregation
Basic Join
Advanced Join
Alternative Queries
Leave a comment below