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