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 课程名,班级;