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.



  1. SELECT *
  2. FROM CITY
  3. WHERE COUNTRYCODE = 'USA'
  4. AND POPULATION > 100000;

download android app