https://www.hackerrank.com/challenges/revising-the-select-query-2/problem
Revising the Select Query II | HackerRank
Query the city names for all American cities with populations larger than 120,000.
www.hackerrank.com
<sql />
select NAME from CITY where POPULATION > 120000 and COUNTRYCODE = 'USA'
'Algorithm > SQL' 카테고리의 다른 글
| [SQL][HackerRank] Japanese Cities' Names (0) | 2020.06.08 |
|---|---|
| [SQL][HackerRank] Japanese Cities' Attributes (0) | 2020.06.08 |
| [SQL][HackerRank] Select By ID (0) | 2020.06.08 |
| [SQL][HackerRank] Select All (0) | 2020.06.08 |
| [SQL][HackerRank] Revising the Select Query I (0) | 2020.06.08 |
