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...






 

No comments:

Post a Comment