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;
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.