반응형
SQL > Basic Select > Revising the Select Query II
Problem
Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA. The CITY table is described as follows:
My Answer
SELECT NAME
FROM CITY
WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA'
반응형
'CODING TEST > SQL : HackerRank' 카테고리의 다른 글
| [MySQL] Weather Observation Station 4 (0) | 2021.03.31 |
|---|---|
| [MySQL] Weather Observation Station 3 (0) | 2021.03.30 |
| [MySQL] Weather Observation Station 1 (0) | 2021.03.30 |
| [MySQL] Japanese Cities' Names (0) | 2021.03.29 |
| [MySQL] Japanese Cities Attributes (0) | 2021.03.29 |
| [MySQL] Select By ID (0) | 2021.03.27 |
| [MySQL] Select All (0) | 2021.03.27 |
| [MySQL] Revising the Select Query I (0) | 2021.03.26 |
댓글