문제
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:
문제해석 & 풀이
CITY테이블의 COUNTRYCODE가 'JPN'(JAPAN)인 NAME 선택
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'문제
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:
문제해석 & 풀이
CITY테이블의 COUNTRYCODE가 'JPN'(JAPAN)인 NAME 선택
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'