This Leetcode problem Classes More Than 5 Students LeetCode Solution is done in SQL.
List of all LeetCode Solution
Classes More Than 5 Students LeetCode Solution
Table of Contents
Problem Statement
| Column Name | Type |
| student | varchar |
| class | varchar |
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 |
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
select
class
from
courses
group by
class
having
count(distinct student) >= 5;Code language: SQL (Structured Query Language) (sql)