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.