Sqliste Querying Data Exercise 2

1. Query the teacher all units that are not duplicated depart column.

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

3. Query all records of the score table in CNO Ascending, degree descending order.

4. Check the number of students in the "95031" class.

5. Check the student number and course number of the highest score in the score table. (sub-query or sort)

6. The query score is greater than 70, less than the Sno column of 90.

7. Check the records of all students in class 95033 and 95031

8. Check for a course CNO with 85 or more results.

9. Check the name, sex and birthday of all teachers and classmates.

10. Check the records of the students who are not named "Wang" in the student table.

11. Query all records in the student table in order of class and age from large to small

Sqliste Querying Data Exercise 2