How can i obtain overall class average by class using SQL ServerI would want the overall by average of scores in a particular class say p1 or p2 correspondingNAMECLASSMTCENGSSTSCIENCETOTALJOHNP190608890328MARKP150605589254WILLIAMP166456788266BECKYP245189079232ROSEP250386789244DAVIDP233677756233ALEXP223294567164thanks in advance

Calculate average for each group in SQL Server

makumbi

How can i obtain overall class average by class using SQL Server?

I would want the overall by average of scores in a particular class say p1 or p2 corresponding

thanks in advance

Joey

0 3

Refer below query.

SQL

SELECT Class,AVG(TOTAL) Average
FROM @Student GROUP BY Class

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html