Prepare > SQL > Basic Select > Japanese Cities' Attributes
2023. 7. 6. 19:09ㆍHackerRank-My SQL
Japanese Cities' Attributes | HackerRank
Query the attributes of all the cities in Japan.
www.hackerrank.com
문제
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
코드
SELECT * FROM CITY
WHERE COUNTRYCODE = 'JPN';
'HackerRank-My SQL' 카테고리의 다른 글
| Prepare > SQL > Basic Select > Weather Observation Station 1 (0) | 2023.07.06 |
|---|---|
| Prepare >SQL > Basic Select > Japanese Cities' Names (0) | 2023.07.06 |
| Prepare > SQL > Basic Select > Select By ID (0) | 2023.07.06 |
| Prepare > SQL > Basic Select > Select All (0) | 2023.07.06 |
| Prepare > SQL > Basic Select > Revising the Select Query II (0) | 2023.07.06 |