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';

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';

select name from city where countrycode='JPN';

select name from city where countrycode = 'JPN';

select name from city where countrycode='JPN';