SDB101 » Select: Query 5
 
Query: What is the average population of the noncapital cities listed in the City table?

SELECT AVG(Ci.Pop)
FROM CITY Ci
WHERE Ci.Capital = ‘N’

Query: What is the average GDP grouped by continent?

SELECT Co.Cont,AVG(Co.GDP) AS Continent-GDP
FROM COUNTRY Co
GROUP BY Co.Cont

Última modificación: Thursday, 17 de November de 2005, 17:22