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 - clean & correct

Let me know if you have any questions!

SELECT NAME
  FROM CITY
 WHERE COUNTRYCODE = 'JPN';

(From my HackerRank repo on GitHub.)

MySQL code-

SELECT name FROM city 
WHERE countrycode ='jpn';

MySQL:

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

ORACLE:

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

MS SQL Server:

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

You can try this one : select NAME from CITY where COUNTRYCODE = 'JPN';

select name from CITY where COUNTRYCODE = 'JPN'

Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

select name from city where countrycode='JPN'

Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';