Description

Q1)Create a CITY table with the following column.
The CITY table is described as follows:

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.
Sample input:
|3965| Corona | USA | California | 90000 |
|3973| Concord | USA | California | 121780 |
|3977| Cedar Rapids| USA | Iowa | 120758 | |3982| Coral Springs| USA |Florida | 87456 |
Sample output:
|3977| Cedar Rapids| USA | Iowa | 120758 |
Q2) Query the total population of all cities in CITY where
District is California
The CITY table is described as follows:

Sample input:
|3965| Corona | USA | California | 90000 |
|3973| Concord | USA | California | 121780 |
|3977| Cedar Rapids| USA | Iowa | 120758 | |3982| Coral Springs| USA |Florida | 87456 |
Sample output:
211780
Q3) Query the average population for all cities in CITY, rounded down to the nearest integer.
The CITY table is described as follows:

Sample input:
|3965| Corona | USA | California | 90000 |
|3973| Concord | USA | California | 121780 |
|3977| Cedar Rapids| USA | Iowa | 120758 | |3982| Coral Springs| USA |Florida | 87456 |
Sample output:
124540