HackerRank: Japanese Cities' Names
Question and Answer:

Key Points:
What the Query Does
- Selects the NAME of every city located in Japan
Key Condition
COUNTRYCODE = 'JPN'filters rows to only Japanese cities
Why It Works
Only the NAME column is returned, exactly as the problem asks
COUNTRYCODE correctly identifies Japan in the table