2-17.sql

一个数据库的选课系统

select avg(grade) 平均分
from courses,enrolls,teachers,sections
where courses.course=enrolls.course and teachers.teacher=sections.teacher and coursename='english composition' and teachername like '%Engle'