You are viewing a single comment's thread. Return to all comments →
Try with my solution in (DB2) :
SELECT AVG(CAST(POPULATION AS DECIMAL (9, 3))) AS POPAVG FROM CITY WHERE (DISTRICT='California');
Revising Aggregations - Averages
You are viewing a single comment's thread. Return to all comments →
Try with my solution in (DB2) :
SELECT AVG(CAST(POPULATION AS DECIMAL (9, 3))) AS POPAVG FROM CITY WHERE (DISTRICT='California');