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.
Basically in this question we need to find out all the names from the CITY table which are having population > 120000 and countrycode = 'USA' , so here is solution for this query :
SELECT NAME FROM CITY
WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA' ;
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 →
Basically in this question we need to find out all the names from the CITY table which are having population > 120000 and countrycode = 'USA' , so here is solution for this query :
SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = 'USA' ;