Here is Oracle solution from my HackerrankPractice repository:

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';

Feel free to ask if you have any questions :)

MySQL :

SELECT NAME
FROM CITY 
WHERE 
    COUNTRYCODE = 'JPN'

mysql

SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN' 

SELECT DISTINCT (NAME) FROM CITY WHERE COUNTRYCODE='JPN'

My solution: SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN'

select name from city where countrycode='JPN'

change oracle to mysql if you get an error message and try again

I'm not sure whether it's asking for distinct names and there's only one test case so I'll just throw this out here:

SELECT DISTINCT(NAME)
FROM CITY
WHERE COUNTRYCODE = 'JPN';

btw it works

my mysql code is : select name from city where countrycode='jpn';