---
description: January 17, 2024
---

# 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:

<figure><img src="https://3402520177-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6s691pQpzN41rNo5Bip4%2Fuploads%2FJEecZPgmo2SbSXekHZTX%2Fimage.png?alt=media&#x26;token=754ad02f-507c-4353-8673-2919ef79f7b4" alt=""><figcaption></figcaption></figure>

```sql
SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';
```
