数据查询练习1~11

--1.
select * from T_HQ_STUDENT;

select SNAME, SSEX, CLASS from T_HQ_STUDENT;

--2.
select distinct DEPART from T_HQ_TEACHER;

--3.
select * from T_HQ_STUDENT;

--4.
select * from T_HQ_SCORE where DEGREE between 60 and 80;

--5.

select * from T_HQ_SCORE where DEGREE in ('85','86','88');

--6.
select * from T_HQ_STUDENT where SSEX like'女' and CLASS like '95031';

select *from T_HQ_STUDENT where CLASS = '95031' and SSEX = '女';

--7.
select CLASS from T_HQ_STUDENT order by CLASS desc;

--8.
select CNO,DEGREE from T_HQ_SCORE order by CNO asc ,DEGREE desc;

--9.
select CLASS,count(1)as 数量 from T_HQ_STUDENT group by CLASS having CLASS = '95031';

--10.
select * from T_HQ_SCORE where DEGREE >= all (select DEGREE from T_HQ_SCORE);

--11.
select CNO,count(1) as 数量, avg(DEGREE) as 平均值 from T_HQ_SCORE group by CNO;