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