Hackerrank – Revising the Select Query – 1

Problem Statement
A description of the problem can be found on Hackerrank.

Solution
Select all columns and filter by CountryCode and Population.

I created solution in:

All solutions are also available on my GitHub.

SQL

Select name from City
where CountryCode='USA' and population > 120000;

1 2	Select name from City where CountryCode='USA' and population > 120000;