African Cities 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 African Cities EasySQL (Basic) HackerRank Solution
select
ci.name
from
city ci
join country co on (co.code = ci.countrycode)
where
co.continent = 'Africa'
;
SQL (Basic)
SQL (Intermediate)
SQL (Advanced)
Basic Select
Advanced Select
Aggregation
Basic Join
Advanced Join
Alternative Queries
Leave a comment below
Related posts:
Japanese Cities’ Attributes EasySQL (Basic) – SQL – HackerRank Solution
Japanese Cities’ Names EasySQL (Basic) – SQL – HackerRank Solution
Select By ID EasySQL (Basic) – SQL – HackerRank Solution
Weather Observation Station 12 EasySQL (Basic) – SQL – HackerRank Solution
Revising Aggregations – Averages EasySQL (Basic) – SQL – HackerRank Solution
Weather Observation Station 2 EasySQL (Basic) – SQL – HackerRank Solution
