Japanese Cities' Attributes

- Japanese Cities' Attributes

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

The CITY table is described as follows:

select * from city where countrycode='JPN';

Expected Output

```
1613 Neyagawa JPN Osaka 257315 
```
```
1630 Ageo JPN Saitama 209442 
```
```
1661 Sayama JPN Saitama 162472 
```
```
1681 Omuta JPN Fukuoka 142889 
```
```
1739 Tokuyama JPN Yamaguchi 107078 
```

Tags hackerrank_sql_easy

Post a Comment