Revising the Select Query II
BASIC SELECT
Query the NAME field for all American cities in the CITY table with populations larger than 120000
. The CountryCode for America is USA
.
The CITY table is described as follows:
SELECT name FROM City WHERE population > 120000 AND countrycode = 'USA'
Last updated
Was this helpful?