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: