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.
The query is simple but here are the problems I faced the resolutions.
1. switch to MySQL
2. do not leave any blank lines, just 1 line of query
3. 12 is follwed by four zeros :) and i kept writing 12000
4. keep the where clause within parenthesis
select NAME from CITY where (COUNTRYCODE = 'USA' and POPULATION > 120000);
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 II
You are viewing a single comment's thread. Return to all comments →
The query is simple but here are the problems I faced the resolutions. 1. switch to MySQL 2. do not leave any blank lines, just 1 line of query 3. 12 is follwed by four zeros :) and i kept writing 12000 4. keep the where clause within parenthesis select NAME from CITY where (COUNTRYCODE = 'USA' and POPULATION > 120000);