~고군분투 인생살이~

[EASY] Revising the Select Query II 본문

SQL/HACKER_RANK

[EASY] Revising the Select Query II

소금깨 2022. 10. 11. 23:38
 

Revising the Select Query II | HackerRank

Query the city names for all American cities with populations larger than 120,000.

www.hackerrank.com

 

문제 조건

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

 

문제 풀이 

select name
from city
where countrycode = 'USA'
and population > 120000
저작자표시 (새창열림)

'SQL > HACKER_RANK' 카테고리의 다른 글

[MEDIUM] The PADS  (0) 2022.10.12
[EASY] Select All  (0) 2022.10.12
[EASY] Revising the Select Query I  (0) 2022.10.11
[HACKER_RANK] Interviews  (0) 2022.06.13
[HACKER_RANK] THE-PADS  (0) 2022.06.13
'SQL/HACKER_RANK' Related Articles more
Comments