Hello coders, In this post, you will learn how to solve the Revising the Select Query I Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.
Query all columns for all American cities in CITY with populations larger than
100000. The CountryCode for America is
The CITY table is described as follows:
Revising the Select Query I Hacker Rank Solution
SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION >100000;