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

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 filters the rows and includes only those cities where the population is larger than 120,000.
  • AND COUNTRYCODE = 'USA': This additional condition ensures that only American cities (USA) are included in the result, based on the CountryCode column.