revising_the_select_query_2.sql

-- Author: Mahmoud Gadallah

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