https://www.hackerrank.com/challenges/revising-the-select-query/problem
Revising the Select Query I | HackerRank
Query the data for all American cities with populations larger than 100,000.
www.hackerrank.com
select * from CITY where POPULATION > 100000 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 II (0) | 2020.06.08 |
