Friday, 7 February 2014

Complex sql query -group by

What is the average total amount of penalties for players who live in Stratford and Inglewood? 



SELECT AVG(TOTAL) FROM (SELECT PLAYERNO, SUM(AMOUNT) AS TOTAL FROM PENALTIES GROUP BY PLAYERNO) AS TOTALS WHERE PLAYERNO IN (SELECT PLAYERNO FROM PLAYERS WHERE TOWN = 'Stratford' OR TOWN = 'Inglewood') 


------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment