Problem Statement
Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.
Solution
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;
Disclaimer: The above Problem (Select All queary in SQL ) is generated by Hackerrank but the Solution is Provided by Rohit S. Pathak. 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.