Skip to main content

Revising the Select Query II

· One min read
Kaustubh Kulkarni

Query the NAME field for all American cities in the CITY table with populations larger than 120_0. The ountryCode for America is USA.

The CITY table is described as follows:

Answer :

select NAME as cities from CITY where POPULATION > 120000 and COUNTRYCODE='USA' ;