Most Completed Course
Return the course with the most completions and the number of completions.
Table schema
Enrollments(id INT PRIMARY KEY, student VARCHAR(10), course VARCHAR(10), progress INT, completed INT)Sample data
id | student | course | progress | completed
1 | Ann | SQL | 100 | 1
2 | Bob | SQL | 40 | 0
3 | Cy | SQL | 100 | 1
4 | Ann | Python | 60 | 0
5 | Dee | Python | 100 | 1
6 | Eli | Python | 10 | 0
7 | Fay | Python | 0 | 0
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.