HackerRank MySQL - Revising the Select Query I
Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.
- SELECT *
- FROM CITY
- WHERE COUNTRYCODE = 'USA'
- AND POPULATION > 100000;
Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.
- SELECT *
- FROM CITY
- WHERE COUNTRYCODE = 'USA'
- AND POPULATION > 100000;