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
Related posts:
Average Population EasySQL (Basic) – SQL – HackerRank Solution
Japan Population EasySQL (Basic) – SQL – HackerRank Solution
Population Density Difference EasySQL (Basic) – SQL – HackerRank Solution
Population Census EasySQL (Basic) – SQL – HackerRank Solution
Weather Observation Station 1 EasySQL (Basic) – SQL – HackerRank Solution
Weather Observation Station 15 EasySQL (Basic) – SQL – HackerRank Solution
