当前位置:网站首页>每日sql-统计各个专业人数(包括专业人数为0的)
每日sql-统计各个专业人数(包括专业人数为0的)
2022-08-11 05:36:00 【吃再多糖也不长胖】
每日sql-统计各个专业人数(包括专业人数为0的)
DDL
CREATE TABLE IF NOT EXISTS student (student_id INT,student_name VARCHAR(45), gender VARCHAR(6), dept_id INT);CREATE TABLE IF NOT EXISTS department (dept_id INT, dept_name VARCHAR(255));insert into student (student_id, student_name, gender, dept_id) values (1, 'Jack', 'M', 1);insert into student (student_id, student_name, gender, dept_id) values (2, 'Jane', 'F', 1);insert into student (student_id, student_name, gender, dept_id) values (3, 'Mark', 'M', 2);insert into department (dept_id, dept_name) values (1, 'Engineering');insert into department (dept_id, dept_name) values (2, 'Science');insert into department (dept_id, dept_name) values (3, 'Law');

sql
select t2.dept_name,count(t1.student_id) as student_number from student t1 right join department t2 on t1.dept_id = t2.dept_id group by t2.dept_name;

边栏推荐
猜你喜欢
随机推荐
拼多多API接口大全
grep、sed、awk
查看CPU和其他硬件温度的软件
MySQL01
mmdetection的安装和训练、测试didi数据集的步骤(含结果)
矩阵分析——矩阵分解
TOP2 Add two numbers
Eight-legged text jvm
SECURITY DAY05 (Kali system, scanning and caught, SSH basic protection, service SECURITY)
华为防火墙-6
My meeting of the OA project (meeting seating & review)
HCIP MGRE\OSPF Comprehensive Experiment
HCIP OSPF动态路由协议
Local yum source build
使用路由器DDNS功能+动态公网IP实现外网访问(花生壳)
【LeetCode】851.喧闹与富有(思路+题解)
TOP2两数相加
知识蒸馏Knownledge Distillation
损失函数——负对数似然
训练分类器









