[HackerRank-SQL] Basic Select

 

 

#1 Revising the Select Query1

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

 

#2 Revising the Select Query2

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000

 

#3 Select All

SELECT *
FROM CITY

 

#4 Select By ID

SELECT *
FROM CITY
WHERE ID = 1661

 

#5 Japnese Cities' Attributes

SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN'

 

#6 Japnese Cities' Name

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN'

 

#7 Weather Observation Station1

SELECT CITY, STATE
FROM STATION

 

 

#8 Weather Observation Station 3

SELECT DISTINCT CITY
FROM STATION
WHERE MOD(ID, 2)=0