Revising the Select Query II
- URL : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem
- Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.
- MySQL, Oracle Solution
1
2
3
SELECT name
FROM city
WHERE population > 120000 and countrycode = 'USA';