DEV Community

Cover image for HackerRank SQL preparation; Revising the Select Query II(MySQL)
Christian Paez
Christian Paez

Posted on

1

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';
Enter fullscreen mode Exit fullscreen mode

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.

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more