Last updated on October 9th, 2024 at 10:31 pm

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

Problem Statement

(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:

Output:

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.

1. Classes More Than 5 Students LeetCode Solution MySQL

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