What SQL statement do we use to find the average exam score for EXAM ID

Q. What SQL statement do we use to find the average exam score for EXAM ID= 1 ?

(a) SELECT AVG(EXAM_SCORE) FROM EXAM_RESULTS;

(b) SELECT AVG(EXAM_SCORE) FROM EXAM_RESULTS GROUP BY EXAM_ID WHERE EXAM_ID = 1;

(c) SELECT AVG(EXAM_SCORE) FROM EXAM_RESULTS GROUP BY EXAM_ID HAVING EXAM_ID = 1;

(d) SELECT COUNT (EXAM_SCORE) FROM EXAM_RESULTS WHERE EXAM_ID = 1;

Consider  this table --

You can understand by seeing this video ---

Answer :-

(c) SELECT AVG(EXAM_SCORE) FROM EXAM_RESULTS GROUP BY EXAM_ID HAVING EXAM_ID = 1;