Leetcode力扣 MySQL数据库 580 统计各专业学生人数

最新推荐文章于 2024-05-30 07:32:10 发布

ziko-1101

最新推荐文章于 2024-05-30 07:32:10 发布

阅读量1.2k

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 java sql

本文链接：https://blog.csdn.net/m0_46458212/article/details/127285605

版权

580 统计各专业学生人数

sql架构

create table if not exists student_580 (student_id int,student_name varchar(45), gender varchar(6), dept_id int);
create table if not exists department_580 (dept_id int, dept_name varchar(255));
truncate table student_580;
insert into student_580 (student_id, student_name, gender, dept_id) values ('1', 'jack', 'm', '1');
insert into student_580 (student_id, student_name, gender, dept_id) values ('2', 'jane', 'f', '1');
insert into student_580 (student_id, student_name, gender, dept_id) values ('3', 'mark', 'm', '2');
truncate table department_580;
insert into department_580 (dept_id, dept_name) values ('1', 'engineering');
insert into department_580 (dept_id, dept_name) values ('2', 'science');
insert into department_580 (dept_id, dept_name) values ('3', 'law');