Database Practice Answers--1-8 Questions

1. Query the sname, Ssex, and class columns of all records in the student table.

Select T.sname,t.ssex,t.sclass from student t;

2, the inquiry teacher all units namely does not duplicate depart column.

Select * from teacher T where t.depart= ' computer system ';

3. Query all records of student table.

Select *from student T;

4. Query all records from 60 to 80 of the scores in the score table.

SELECT * FROM Student t where T.sno in (select E.sno from score e where degree between and 80);

5. Check the record of 85, 86 or 88 in the score table.

SELECT * FROM Student t where T.sno in (select E.sno from score e where e.degree= ' ' or e.degree= ' ' or e.degree= ' 88 ');

6, inquires the student table "95031" class or the sex is "the female" the classmate record.

Select * from student t where t.ssex= ' female ' or t.sclass= ' 95031 ';

7. Query the student table for all records in descending order of class.

SELECT * FROM STUDENT t order by Sclass;

8, in CNO Ascending, Degree descending query score all records of the table.

SELECT * FROM score T ORDER by CNO Asc,degree desc;

Database Practice Answers--1-8 Questions