Revising the Select Query II - Hacker Rank Solution

---

Problem :-

Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.

Input Format

The CITY table is described as follows: 

---

Solution :-

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

the hole problem statement are given by HackerRank.com but the solution are generated by the codeworld19 authority if any of the query regarding this post or website fill the following contact form thank you.