Oracle Queries 12 Questions, etc.

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

Select cno,Count(CNO),avgfromgroup by has Count(CNO)>=5 and substr (CNO,0,1)='  3'

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

Select  from where degree><

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

Select  from

15. Check the Sno,cname and degree columns of all students .

Select  from

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

Select  from

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

Select class,cno,avg from score,student t  where class=' 95033 ' Group  by Cno,class

Oracle Queries 12 Questions, etc.