[凡鸽鸽]《课内学习12》MYSQL 实验12 having 子句

课内学习12 — MYSQL

实验12 having 子句源码如下：

1.create database xscj;
use xscj;
source C:\Users\Administrator\Desktop\sy111.sql

2.create database yggl;
use yggl;
source C:\Users\Administrator\Desktop\sy112.sql

3.use xscj;

4.select month(出生日期) as 出生月,count(*) as 人数 from xs group by 出生月;

5.select 学号,姓名,课程名,成绩 from xs join xs_kc using(学号) join kc using (课程号)
where 成绩 between 60 and 69 group by 学号 having count(学号)>1;

6.select substring(学号,4,2) as 班级,课程名,学号,姓名,max(成绩) from xs join xs_kc using(学号)
join kc using(课程号) group by 课程名,班级;