SQL query Statement Practice

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

12. Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.

13, the query score is greater than 70, less than 90 of the SNO column.

14. Sname, CNO and degree columns for all students are queried.

15. Check the SNO, CNAME and degree columns of all students.

16. Check the sname, CNAME and degree columns of all students.

17. Check the average score of "95033" class students.

SQL query Statement Practice