HackerRank SQL preparation; Revising the Select Query II(MySQL)

Problem Statement:

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

Link:HackerRank - Revising the SELECT Query 2

Solution:

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

Explanation:

• 
  SELECT NAME: This part of the query specifies that you want to retrieve the NAME field.


• 
  FROM CITY: Indicates that you are selecting data from the CITY table.


• 
  WHERE POPULATION > 120000: This condition …

america american cities city hackerrank link mysql name preparation problem query select solution sql statement usa writeups