Here is Oracle solution from my HackerrankPractice repository:

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';

Feel free to ask if you have any questions :)

SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN'; i am writing this query but test case is not passing . what is issue in this query to pass query

I'm a FE dev who never works with SQL commands but ripping through these fast. Are the last two hard or something?

select NAME from CITY where COUNTRYCODE like 'JPN';

my solution:

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN';

Here is my answer SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN' ;

you can also query all the attributes using this: SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN' ;

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN' group by NAME;

select name from city where countrycode ='JPN';

select name from CITY where countrycode='jpn'