Revising the Select Query I - Hacker Rank Solution

---

Problem :-

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

Input Format

The CITY table is described as follows: 

---

Solution :-

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

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.