SQL Tutorial

Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.

Input Format:

Solution:

select name from city where countrycode='USA' and population > 120000;

#HackerRank #Query