Hello Coders, Welcome to our Hacker Rank SQL Solutions Series. Today we are going to solve second problem of this SQL Series which is Revising the Select Query II Hacker Rank Solution.
Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.
The CITY table is described as follows:
Solution – Revising the Select Query II
select name from city where countrycode = 'USA' and population > 120000
Disclaimer: The above Problem (Revising the Select Query II) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.