leecode 数据库：596. 超过5名学生的课

小布先生~噫嘘唏

于 2023-05-20 12:12:54 发布

阅读量1.2k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： leecode数据库文章标签：数据库 sql mysql big data 大数据

本文链接：https://blog.youkuaiyun.com/Clittle225/article/details/130779958

数据导入：

Create table If Not Exists Courses (student varchar(255), class varchar(255));
Truncate table Courses;
insert into Courses (student, class) values ('A', 'Math');
insert into Courses (student, class) values ('B', 'English');
insert into Courses (student, class) values ('C', 'Math');
insert into Courses (student, class) values ('D', 'Biology');
insert into Courses (student, class) values ('E', 'Math');
insert into Courses (student, class) values ('F', 'Computer');
insert into Courses (student, class) values ('G', 'Math');
insert into Courses (student, class) values ('H', 'Math');
insert into Courses (student, class) values ('I', 'Math');

表: Courses

+-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +-------------+---------+ (student,