题干:
检索数计学院的叶凡选修课程的平均分。(分数四舍五入取整)
提示:请使用SELECT语句作答。
表结构:
定义表结构的SQL语句如下:
CREATE TABLE student (
sno varchar(6) NOT NULL ,
sname varchar(10) ,
sex char(2) ,
nation char(2) ,
pnum char(18) ,
birth date ,
phone char(11) ,
dept varchar(20) ,
PRIMARY KEY (sno)
) ;
CREATE TABLE course (
cno varchar(6) NOT NULL,
cname varchar(20) ,
credit int(11) ,
attribute varchar(10) ,
PRIMARY KEY (cno)
) ;
CREATE TABLE score (
sno varchar(6) NOT NULL,
cno varchar(6) NOT NULL,
term varchar(15),
grade int(11),
PRIMARY KEY (sno,cno)
) ;
表样例
student
表:
score
表:
输出样例:
select sname,round(avg(grade),0) as avggrade
from score as sco_re
inner join student as stu on sco_re.sno = stu.sno
where stu.sname = '叶凡'
group by sco_re.sno