SQL Tutorial

Query a list of CITY and STATE from the STATION table.

Input Format The STATION table is described as follows:

Solution:

select CITY,STATE from STATION order by CITY,STATE;

Query all columns (attributes) for every row in the CITY table.

Input Format

Solution:

select *from city;

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

Input Format:

Solution:

select name from city where countrycode='USA' and population > 120000;

#HackerRank #Query

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

Input Format:

Solution:

select *from CITY where population> 100000 and countrycode='USA';

#HackerRank #Codersarts #SQL #QuerySolution #SQLQUERYHELP