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:

1449729804 f21d187d0f CITY
SELECT *
FROM CITY
WHERE
    COUNTRYCODE = 'USA'
    AND POPULATION > 100000;
Previous Article

Weather Observation Station 3

Next Article

Japanese Cities' Attributes

Write a Comment

Leave a Comment

Your email address will not be published. Required fields are marked *