Jobs on the SQLite database 2

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

SELECT Sname,ssex,class from Student

2 Query teachers All units are not duplicates of the depart column.

SELECT depart from Teachear

3 query all records of the student table.

SELECT * from Student

4 query all records in the score table with scores from 60 to 80.

SELECT degree from score where degree>60 and degree<80

5 Check the records in the score table for grades 85, 86, or 88.

SELECT degree from score WHERE degree=85 or degree=86 or degree=88

6 Check the student table in the "95031" class or sex for "female" students record.

SELECT * from Student WHERE ssex= ' female ' and class= ' 95031 '

SELECT * from Student WHERE ssex= ' female ' OR class= ' 95031 '

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

SELECT * from Student ORDER by class DESC

8 queries all records of the score table in CNO Ascending, degree descending order.

Ascending: SELECT *from score ORDER by degree ASC

Descending: SELECT *from score ORDER by degree DESC

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

SELECT * from Student WHERE class= ' 95031 '

Jobs on the SQLite database 2