Write an SQL query to calculate the average population for all cities in the CITY table and round the result to the nearest integer.

Here’s how you can write an SQL query to calculate the average population for all cities in the CITY table and round the result to the nearest integer:

SQL Query

SELECT ROUND(AVG(population)) AS average_population
FROM CITY;

Explanation

1. AVG Function: This function computes the average of a specified column. In this case, it calculates the average of the population column.
2. ROUND Function: This function rounds the calculated average to the nearest integer.
3. AS Clause: This part renames the output column to average_population for better readability.

Final Answer

The query will return the average population of all cities in the CITY table, rounded to the nearest integer.