Revising the Select Query II¶
Tags: Easy
Links: https://www.hackerrank.com/challenges/revising-the-select-query-2/problem
Query the names of all American cities in CITY with populations larger than 120000
. The CountryCode for America is USA
.
Input Format
The CITY table is described as follows:
SELECT name
FROM city
WHERE countrycode = 'USA' AND population > 120000;