Find the output of the MySQL query based on the given Table-STUDENT (ignore…
2023
Find the output of the MySQL query based on the given Table-STUDENT (ignore the output header) Table: STUDENT Query: SELECT SEC, AVG (MARKS) FROM STUDENT GROUP BY SEC HAVING MIN (MARKS) > 80;
- A.
B 83
- B.
A 84
- C.
A 84
B 83 - D.
A 83
B 80
Attempted by 1262 students.
Show answer & explanation
Correct answer: B
Section A: Marks = 83, 85
MIN(MARKS) = 83 → greater than 80 ✅
AVG(MARKS) = (83 + 85) / 2 = 84
Section B: Marks = 86, 80
MIN(MARKS) = 80 → not greater than 80 ❌
So, Section B is excluded.
📌 Final Output A 84 ✅ Correct Option (2) A 84 (Option 3 also shows the same result, but option 2 is the intended answer)