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:

CODE:

SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = "USA";

Here we 1st call the "*" means whole table data from CITY table then we pass a where statement from filter our query.