mysql第三次作业

select * from student;

select * from score;

select * from student limit 1,4;

select * from student where department in ('计算机系','英语系');

select * from student where year(now()) - birth < 22;

select department,count(*) as 人数 from student group by department;

select c_name,max(grade) from score group by c_name;

select c_name,grade from score where stu_id = (select stu_id from student where name = '李广昌');

select * from student inner join score on student.id = score.stu_id;

select stu_id,sum(grade) from score group by stu_id;

select c_name,round(avg(grade)) from score group by c_name;

select * from student where id in (select stu_id from score where c_name = '计算机' and grade < 95);

select * from score where c_name = '计算机' order by grade desc;

select id from student union select stu_id from score;

select name,department,c_name,grade from student inner join score on student.id = score.stu_id where name like '张%' or name like '王%';

select name,birth,department,c_name,grade from student inner join score on student.id = score.stu_id where address like '湖南%';