Scenario: In a Students table containing information about students with columns CourseID, Grade, and StudentID, which SQL query would retrieve courses with an average grade less than $70?$

Context:

Students Table Columns:

StudentID

CourseID

Grade

A

SELECT CourseID, AVG$($Grade$)$ as AvgGrade FROM Students GROUP BY CourseID HAVING AvgGrade $<70$;

B

SELECT CourseID, AVG$(*)$ FROM Students GROUP BY StudentID HAVING AVG$($Grade$)<70$;

C

SELECT $*$ FROM Students GROUP BY CourseID HAVING AVG$($Grade$)<70$;

D

SELECT CourseID, Grade FROM Students HAVING AVG$($Grade$)<70$;