Member Avatar for Samyx

How can I use this query to calculate the max average grade?

SELECT dname, cno, sectno, avg(grade)
FROM enroll
GROUP BY dname, sectno, cno;
  • 2 Contributors
  • 1 Reply
  • 54 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas 
SELECT dname, cno, sectno, avg(grade) as avg_grade
FROM enroll
GROUP BY dname, sectno, cno
ORDER BY avg_grade DESC LIMIT 1
Edited by pritaeas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.