[ SQL ] HackerRank Basic - MySQL 답안 정리(1)

Revising the Select Query 1,2

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

 

Select All

SELECT * FROM CITY

 

Select By ID

SELECT * FROM CITY WHERE ID = 1661

 

Japanese Cities' Attributes & Names

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'