Question

uy JUNI JALES_AMOUNT) FROM SALES
WHERE STORE_ID = 25 AND STORE_ID = 45 GROUP BY STORE_ID;
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;​

Answer 1

Explanation:

Option C) It's the right answer