HackerRank MySQL - Revising the Select Query I

Problem Statement

Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.

Solution

  SELECT FROM CITY WHERE COUNTRYCODE = 'USA'AND POPULATION > 100000;  

Disclaimer: The above Problemis generated by HackerRank but the Solution is Provided by boxessolved. This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.