[SQL] (해커랭크) Revising the Select Query I

Problem

HackerRank > Prepare > SQL > Basic Select > Revising the Select Query I

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

The CITY table is described as follows:

Solution

SELECT *
FROM CITY
WHERE 1=1
and COUNTRYCODE = 'USA'
and POPULATION > 100000
;