Query all column (attributes) for every row in the CITY table.

The CITY table is described as follows:

SELECT * FROM CITY;

“SELECT ALL” HACK:

CODE:

“REVSISNG THE SELECT QUERY 1” HACK:

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 CountryCode = 'USA' AND Population > 100000;