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 |