1. Description
There is a table courses with columns: student and class
Please list out all classes which have more than or equal to 5 students.
2. Runtime Distribution
3. Submission Details
4. Example
student | class |
---|---|
A | Math |
B | English |
C | Math |
D | Biology |
E | Math |
F | Computer |
G | Math |
H | Math |
I | Math |
Should output:
class |
---|
Math |
5. Code
[restabs alignment="osc-tabs-right" responsive="true" icon="true" text="More" seltabcolor="#fdfdfd" seltabheadcolor="#000" tabheadcolor="blue"]
[restab title="MySql" active="active"]
select class from courses group by class having count(distinct student ) >= 5
[/restab]
[/restabs]
Comments | NOTHING