Oracle Query Exercise 24-28

24. The name of the teacher who has more than 5 students who have enrolled in a course

Select  from  where  t.tno= and C.cno=and  =(  Selectfromgroupby hasCount(CNO)> 5  Group by T.tname

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

Select St.sno,st.sname,st.ssex,st.sbirthday,st.class,s.cno,s.degree,c.cname,c.tno,t.tname  from  where st.sno= and C.cno= and C.tno=T.tno

26, the inquiry existence has 85 points above the course CNO.

Select distinct  from where >  -

27. Find out the results table of the "computer Department" teacher teaching course.

Select  from where t.tno= and C.cno=s.cnoand  t.depart=  ' Computer Department '

28. Query the Tname and prof of teachers with different titles of "computer department" and "Electronic Engineering department"

Select  from  wherenot in (theselectfromwhere a.depart!=  and A.prof=b.prof) and in (' computer system  ',' Electrical Engineering Department ')

Oracle Query Practice 24-28