SQLite statement Exercises

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

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

3. Query all records of student table.

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

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

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

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

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

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

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

SQLite statement Exercises