하미's 블로그

Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: # 나의 해답 SELECT CITY, STATE FROM STATION;

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';

Query all columns for a city in CITY with the ID 1661. The CITY table is described as follows: # 나의 해답 SELECT * FROM CITY WHERE ID=1661;

Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: # 나의 해답 SELECT * FROM CITY;