This Leetcode problem ** Classes More Than 5 Students LeetCode Solution** is done in SQL.

*List of all LeetCode Solution*

*List of all LeetCode Solution*

**Classes More Than 5 Students LeetCode Solution**

## Table of Contents

**Problem Statement**

Column Name | Type |

student | varchar |

class | varchar |

**Table:**

`Courses`

(student, class) is the primary key (combination of columns with unique values) for this table. Each row of this table indicates the name of a student and the class in which they are enrolled.

Write a solution to find all the classes that have **at least five students**.

Return the result table in **any order**.

The result format is in the following example.

**Example 1:****Input:**

student | class |

A | Math |

B | English |

C | Math |

D | Biology |

E | Math |

F | Computer |

G | Math |

H | Math |

I | Math |

**Courses table:**

**Output:**

class |

Math |

**Explanation:**

– Math has 6 students, so we include it.

– English has 1 student, so we do not include it.

– Biology has 1 student, so we do not include it.

– Computer has 1 student, so we do not include it.

*Classes More Than 5 Students LeetCode Solution MySQL*

*Classes More Than 5 Students LeetCode Solution MySQL*

```
select
class
from
courses
group by
class
having
count(distinct student) >= 5;
```

Code language: SQL (Structured Query Language) (sql)