mysql第三次作业

(1)

 select * from student;
 select * from score;

(2)

 select * from student limit 2,5;

(3)

select * from student join score on student.id=score.stu_id where department='计算机系' or department='英语系';

(4) 

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

（5）、

select department'院系',count(1)'人数' from student join score on score.stu_id=student.id group by department ;

（6）、

select c_name'科目' , max(grade)'最高成绩' from score group by c_name;

(7)、

 select c_name , grade from student join score on score.stu_id=student.id where name = '李广昌';

(8)

select student.* ,score.id, c_name , grade from student join score on student.id=score.stu_id;

(9)

 select name , sum(grade) from student join score on student.id=score.stu_id group by name;

(10)

select name'姓名' , avg(grade)'平均成绩' from student join score on student.id=score.stu_id group by name;

(11)

 select student.* , score.id,c_name,grade from student join score on student.id=score.stu_id where c_name='计算机' and grade<95;

(12)

 select grade'计算机成绩' from student join score on student.id=score.stu_id where c_name='计算机' order by grade desc;

(13)

select * from student left outer join score on student.id=score.stu_id union  select * from student right outer join score on student.id=score.stu_id;

(14)

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

(15)

select name'姓名',year(now())-birth'年龄',department'院系',c_name'考试科目',grade'成绩' from student join score on student.id=score.stu_id where address like'%湖南%';