sql notes: hackerrank 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:

Analysis

• query names ==> SELECT NAME
• in CITY table ==> FROM CITY
• populations larger than 120000 ==> POPULATION > 120000
• CountryCode for America is USA ==> COUNTRYCODE = ‘USA’
• American cities with populations larger than 120000 ==>
  WHERE COUNTRYCODE = ‘USA’ AND POPULATION > 120000

Solution

1

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;

Link

Revising the Select Query 2
(中文版) SQL 笔记: Hackerrank Revising the Select Query 2