Classes More Than 5 Students

https://leetcode.com/submissions/detail/215940747/

Your runtime beats 97.53 % of mysql submissions.

LeetCode 12/8/2019
# Write your MySQL query statement below
SELECT class FROM (SELECT DISTINCT student, class FROM courses) as pplz
GROUP BY class
HAVING Count(student) >= 5