We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT * FROM city WHERE countrycode = "usa" AND population > 100000;
note:
1. Use "Lower case" for city, countrycode, population.
2. And for the statement , clause and operator use "Upper Case".
note2:
I have done upper query in mysql and it accepted double quotes for countrycode which is usa. But in case you happen to use any other language use single quote.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Revising the Select Query I
You are viewing a single comment's thread. Return to all comments →
SELECT * FROM city WHERE countrycode = "usa" AND population > 100000; note: 1. Use "Lower case" for city, countrycode, population. 2. And for the statement , clause and operator use "Upper Case".
note2: I have done upper query in mysql and it accepted double quotes for countrycode which is usa. But in case you happen to use any other language use single quote.