Saturday, September 10, 2022

HackerRank: SQL Basic Select 2

Question:

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

The CITY table is described as follows:

 


Answer:

SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE='USA';


No comments:

Post a Comment