Hacker Rank Problem Solving on SQL

                                           # PROBLEM-1

Hey Guys , I hope that you are Enjoying with my Blogs writing and this the problem solution of "HACKER RANK SQL ".This solution will definitely will help you.

Problem Statement:  Revising the Select Query I

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

The CITY table is described as follows:

Solution: 

•  First of all read the problem statements carefully.
• Write Query to show the all columns for all American cities which is already has in the table "CITY". 
• And Countrycode is "USA"
• With population larger than 100000.

             select * from CITY where CountryCode ='USA' AND Population > 100000

                                                    # PROBLEM-2

Problem Statement:  Revising the Select Query II

Thank You...