数据库之MySQL的使用2（数据查询1）

 select sname,2020-sage "stu_birthday"
  from stu;

select  sdegree
  from score;

select distinct sdegree
 from score;

select distinct sname,sage
    -> from stu;

 select *
    -> from course
    -> where cname='高等数学';

 select sname,sage
    -> from stu
    -> where sage<>17;

 select sname,sage
    -> from stu
    -> where sage between 15 and 19;

 select sname,sage
    -> from stu
    -> where sage not between 17 and 18;

 select sname,sage
    -> from stu
    -> where sage in (18,19);

select sname
-> from stu
-> where ssex='男’and sage<17;

 select sno,sdegree
    -> from score
    -> where cno=3 order by sdegree desc;

select sno,count(cno)
    -> from score
    -> group by sno;

select sno,count(cno)
    -> from score
    -> group by sno
    -> having avg(sdegree)>80;