. Write and execute a query that will determine the average age of customers broken out by the city in which they reside. Note: Make sure that the average age is not truncated to an integer.

Respuesta :

Answer:

SELECT resid_city, avg(convert(float,age))

  FROM customer

 GROUP BY resid_city

Explanation:

SQL or structured query language is a language used to interact with databases. It is a relational database language, used to create, update, and query the content of databases.

The "SELECT" clause in the query statement above is used to read the content of the customer table querying the table based on the average age of customers grouped by their resident cities to return the "resid_city" and the float number of the average age.

ACCESS MORE