<jupyter_start><jupyter_text>There is a table courses with columns: student and classPlease list out all classes which have more than or equal to 5 students.For example, the table:```+---------+------------+| student | class      |+---------+------------+| A       | Math       || B       | English    || C       | Math       || D       | Biology    || E       | Math       || F       | Computer   || G       | Math       || H       | Math       || I       | Math       |+---------+------------+```Should output:```+---------+| class   |+---------+| Math    |+---------+```Note:The students should not be counted duplicate in each course. select distinct t1.class from courses t1, (select class, count(distinct student) as sc from courses group by class ) t2 where t2.sc >=5 and t2.class = t1.class;<jupyter_code>SELECT
    class
FROM
    (SELECT
        class, COUNT(DISTINCT student) AS num
    FROM
        courses
    GROUP BY class) AS temp_table
WHERE
    num >= 5
;<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.18962075848303392, 'fraction_numerical': 0.008982035928143712, 'mean_word_length': 1.7404371584699454, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '650833', 'license': 'Apache-2.0', 'n_tokens_mistral': 287, 'n_tokens_neox': 269, 'n_words': 103, 'path': '596.ClassesMoreThan5Students.ipynb', 'repo_name': 'charlesxu90/leetcode_py', 'size': '1002'}