当前位置:网站首页>每日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;
边栏推荐
- iptables的状态
- Concurrent programming in eight-part essay
- SATA、SAS、SSD三种硬盘存储性能数据
- arcgis填坑_4
- HCIP-Spanning Tree (802.1D, Standard Spanning Tree/802.1W: RSTP Rapid Spanning Tree/802.1S: MST Multiple Spanning Tree)
- pytorch下tensorboard可视化深坑
- 矩阵分析——Jordan标准形
- 安装cuda10.2下paddlepaddle的安装
- 图的拉普拉斯矩阵
- OA项目之会议通知(查询&是否参会&反馈详情)
猜你喜欢
随机推荐
八股文之mysql
OA项目之我的会议(会议排座&送审)
华为防火墙会话 session table
阿里巴巴规范之POJO类中布尔类型的变量都不要加is前缀详解
抖音关键词搜索商品-API工具
HCIA experiment
SATA、SAS、SSD三种硬盘存储性能数据
SECURITY DAY05 (Kali system, scanning and caught, SSH basic protection, service SECURITY)
Monte Carlo
pytorch下tensorboard可视化深坑
arcmap下的多进程脚本
HCIP BGP neighbor building, federation, and aggregation experiments
升级到Window11体验
HCIP WPN实验
使用路由器DDNS功能+动态公网IP实现外网访问(花生壳)
HCIA实验
OA项目之待开会议&历史会议&所有会议
iptables 基础配置
《Show and Tell: A Neural Image Caption Generator》论文解读
会议OA项目之我的会议