Here is Oracle solution from my HackerrankPractice repository:

SELECT *
FROM CITY
WHERE
    COUNTRYCODE = 'USA'
    AND POPULATION > 100000;

Feel free to ask if you have any questions :)

Try w3 schools exercise before seeing hackerrank discussions. https://www.w3schools.com/sql/sql_where.asp this will help you

no postgres?

The editor is starting from line 7. There is some code on line 4 which is causing the error. Not sure what that code is as it is not visible.

I ended the invisible statement with a ; and though the result is giving an error , it is also executing my query.

; select * from CITY where POPULATION > 100000 and COUNTRYCODE='USA' ;

SELECT * FROM CITY WHERE COUNTRYCODE = "USA" AND POPULATION > 100000 ; WHY RUNTIME ERROR ??