why am I getting "no response on stdout" for the correct code?

MySQL - clean & correct

Let me know if you have any questions!

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

(From my HackerRank repo on GitHub.)

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

correct query :

SELECT name FROM city WHERE population > 120000 and  countrycode like('USA');

MySQL-

SELECT name FROM city
WHERE population > 120000 && countrycode ='usa';

MySQL:

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

ORACLE:

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

MS SQL Server:

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

If you are not getting the process of the SQL query and that you must follow some of the recovery process from the guidance of that and you can also know those process from the help of the Epson tech support for that things.

Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

select name from city where population>120000 and countrycode='USA'

Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

hi guys

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