Here is Oracle solution from my HackerrankPractice repository:

SELECT NAME
FROM CITY
WHERE
    COUNTRYCODE = 'USA'
    AND POPULATION > 120000;

Feel free to ask if you have any questions :)

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;

Getting an error:

select NAME from CITY where POPULATION > '120000' and COUNTRY CODE = 'USA';

select Name from CITY WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA';

The reason many are getting error (panel mentioned) is coz Pop, Countrycode is case senestive.

HERE IS A RIGHT ANS select NAME from CITY where POPULATION>120000 AND COUNTRYCODE='USA';

FIRST WRITE A POPULATION OF CITY TABLE THEN COUNTRY TRY ME CODE......... INJOY!!!!!!!!!!!!!!!!!!

SELECT NAME FROM city WHERE CountryCode LIKE "USA" AND population > 120000

select name from city where countrycode is USA and population > 120000;

getting an error..

As it is list of cities, it should be always in ascending order. We should follow the practices from the base queries

Query:

select name from city where CountryCode = 'USA' and population > 120000 order by name;

Your code did not pass this test case.

Select NAME from CITY WHERE COUNTRYCODE='USA' and POPULATION > 120000

select NAME from CITY where POPULATION>1200000 AND COUNTRYCODE='USA';

IT SEEMS FUNNY,I got error for this