There is a table with test results:
You must display the average test score of schools in mathematics (subject code - 2) :
SELECT schoolid, avg(TestResult100) av FROM result WHERE SubjectCode = 2 GROUP BY SchoolID
Mathematics was handed over only by students from school 1001 and, of course, only the result of this school was displayed in the resulting table. But how to display the result of school 1002 ?
Yes, yes, I know - SQL Server displayed everything correctly, according to the request made. I would like to make such a request so that the result will be something like:
Is it possible to create a SQL query to display such information?