Relative Content

Tag Archive for sqlmysqlsql-serverdatabase

Counting grades of ‘A’ but returning all records

I am trying to figure out a query in SQL Server where I have two tables, Grades & Courses. The query needs to return all the courses with a total count of students that received an ‘A’ for the quarter. Them result set should look like this: