DB/SQL

HackerRank_06. Japanese Cities' Names

_S0_H2_ 2020. 6. 11. 21:36
728x90
반응형

문제 : Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

 

select NAME
from CITY
where COUNTRYCODE = 'JPN';

Neyagawa

Ageo

Sayama

Omuta

Tokuyama

728x90
반응형