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 :)

MySQL - clean & correct

Let me know if you have any questions!

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

(From my HackerRank repo on GitHub.)

Oracle:

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

MySQL:

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

MS SQL Server:

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

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

ORACLE SIMPLE SOLUTION select * from City where population > 100000 and countrycode = 'USA';

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

Why this is NOT working?

楼下的错误原因是因为没有加;导致的，添加后即可

select * from city where name='american' any(select name from city where name='american') and population>100000 order by name;

Need to add ; at the end....