Classes More Than 5 Students

Problem Id: 596 Difficulty: Easy


Intuition

Solution


#!/usr/bin/env python
# coding=utf-8
#
# Author: Lucas
# Date: 2019-08-27 20:42:55


# Write your MySQL query statement below
select class from courses group by class having count(distinct student) > 4;