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;




codesadda.com

Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.

Like us on Facebook | Connect with us on LinkedIn | Subscribe our Channel on Youtube