IT/[SQL] Basic
Japanese Cities' Names
carpe08
2021. 7. 30. 17:32
320x100
Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
# 나의 해답
SELECT NAME
FROM CITY
WHERE COUNTRYCODE ='JPN';
320x100
320x100