Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

To query all columns for American cities in the CITY table with populations larger than 100,000, you can use the following SQL statement:

SELECT * 
FROM CITY 
WHERE Population > 100000 
AND CountryCode = 'USA';

Explanation:

1. SELECT *: This selects all columns from the CITY table.
2. FROM CITY: This specifies that we are querying the CITY table.
3. WHERE Population > 100000: This condition filters the results to include only those cities with a population greater than 100,000.
4. AND CountryCode = 'USA': This further filters the results to include only cities from the USA.

This query will return all the details of cities in the USA that have a population exceeding 100,000.