Getting an error:

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

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;

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

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

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..