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:
Note - Please refer 'Revising the Select Query I' problem to get Create table and sample Input dataset scripts.
Expected Output -
Scottsdale
Corona
Concord
Cedar Rapids
Published By : Shazia Irfan Bebal
