Data Query Practice 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 and 80;

--5.

SELECT * from T_hq_score where degree in (' 85 ', ' 86 ', ' 88 ');

--6.
SELECT * from t_hq_student where SSEX like ' woman ' and CLASS like ' 95031 ';

Select *from t_hq_student where CLASS = ' 95031 ' and SSEX = ' female ';

--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 quantity from T_hq_student Group BY class have class = ' 95031 ';

--10.
SELECT * from T_hq_score where degree >= all (select degree from T_hq_score);

--11.
Select Cno,count (1) as number, AVG (degree) as average from T_hq_score group by CNO;

Data Query Practice 1~11