ÖÐÄÏ´óѧÊý¾Ý¿â¸´Ï°×ܸټ°Ïà¹ØÊÔÌâ

»ú»á×ÜÊÇÁô¸øÓÐ×¼±¸µÄÈË¡£

FROM Student, SC, Course

WHERE Student.Sno=SC.Sno and SC.Cno=Course.Cno; £¨5£©¼ìË÷ÄÐÉúµÄƽ¾ùÄêÁä¡£ select ÐÔ±ð£¬avg£¨ÄêÁ䣩 from student

where ÐÔ±ð=¡®ÄС¯ group by ÐÔ±ð

»òselect avg(ÄêÁä) from »ù±¾Çé¿ö

group by ÐÔ±ð having ÐÔ±ð='ÄÐ'

¡ï£ºÑ§Éú¹ÜÀíϵͳÊý¾ÝÄ£ÐÍÓÐËĸöʵÌ弯ºÏ£º

Student(Sno, Sname, gender, age) Class(Classid, department) Course(Cno, Cname, Ccredit) Teacher(Tno, Tname, age, gender)

ÓйØÓïÒå¹ØÏµ¶¨ÒåÈçÏ£ºÒ»¸öѧÉú(Student)Ö»ÄÜÊôÓÚÒ»¸ö°à¼¶(Class)£¬Ò»¸ö°à¼¶ÓɶàÃûѧÉú×é³É£»Ñ§Éú¿ÉÒÔÑ¡ÐÞ¶àÃſγÌ(Course)£»Ã¿Ãſγ̿ɱ»¶à¸öѧÉúÑ¡ÐÞ£¬Ò²¿ÉÓɶà¸ö½Ìʦ(Teacher)½²ÊÚ£»Ò»¸ö½ÌʦֻÄܽ²ÊÚÒ»Ãſγ̡£ ½âÌâÒªÇó£º

¢Ù¸ù¾ÝÉÏÊöÓïÒå»­³öE¡ªRͼ£¬ÒªÇóÔÚͼÖл­³öÊôÐÔ²¢×¢Ã÷ÁªÏµµÄÀàÐÍ¡£

¢Ú½«E¡ªRͼת»»Îª¹ØÏµÄ£ÐÍ¡££¨ÒªÇó¹ØÏµÄ£Ð͵ÄÊýÁ¿¾¡¿ÉÄÜÉÙ£¬²¢ÔÚ¹ØÏµÄ£ÐÍÖÐÓÃÏ»®Ïß±êÃ÷¸÷¹ØÏµÄ£Ð͵ÄÂ룩

µÚ 29 Ò³ ¹² 29 Ò³

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)