»ú»á×ÜÊÇÁô¸øÓÐ×¼±¸µÄÈË¡£
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 Ò³