Computer Science · Database Management System
Find the output of the following MySQL query based on the given table 'STUDENT': Table: STUDENT +-----+--------+-----+------+ | SID | SNAME | SEC | MARKS| +-----+--------+-----+------+ | 101 | Ameena | A | 83 | | 107 | Arjun | B | 86 | | 112 | Albert | B | 80 | | 120 | Akram | A | 85 | +-----+--------+-----+------+ Query: SELECT SEC, AVG(MARKS) FROM STUDENT GROUP BY SEC HAVING MIN(MARKS) > 80;
- 1B 83
- 2A 84✓
- 3A 84 B 83
- 4B 83 A 80
Correct answer
A 84
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Database Management System?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management System