select 学号,姓名,avg(成绩) from student group by 学号,姓名 having count(*)>=4
select 学号,姓名,系名,avg(成绩)as 平均成绩 from Student as s group by 学号,姓名,系名 hvaing count(课程号)>=4
select a.学号,a.姓名,avg(a.成绩) as 平均 from Student a inner join (select 学号 from Student group by 学号 having count(1)>4) b on a.学号=b.学号 group by a.学号,a.姓名
select 学号,姓名,系名,avg(成绩)as 平均成绩 from Student as s group by 学号,姓名,系名 having count(课程号)>=4
select 学号,姓名,avg(成绩) 平均成绩 from Student group by 学号,姓名 hvaing count(课程号)>=4
select 学号,姓名,avg(成绩) from Student group by 学号,系名,课程号 having (count(课程号)>=4)
select 学号,姓名,avg(成绩) as 平均成绩 from Student group by 学号,姓名 having count(*)>=4
select id,name,avg(degree) as 平均成绩 from student group by id having count(*)>=4
Create table student(学号 int,姓名 varchar(10),系名 varchar(10),课程号 int,成绩 int) Go insert into student select 1,'john','数学系',1,90 union all select 1,'john','数学系',2,91 union all select 1,'john','数学系',3,92 union all select 1,'john','数学系',4,93select 学号,姓名,系名,AVG([成绩]) as [平均成绩] from student group by 学号,姓名,系名 having COUNT([课程号]) >=4
学号,姓名,系名,avg(成绩)as 平均成绩
from
Student as s
group by 学号,姓名,系名
hvaing count(课程号)>=4
from Student a
inner join (select 学号 from Student group by 学号 having count(1)>4) b
on a.学号=b.学号
group by a.学号,a.姓名
学号,姓名,系名,avg(成绩)as 平均成绩
from
Student as s
group by 学号,姓名,系名
having count(课程号)>=4
select
学号,姓名,avg(成绩) 平均成绩
from Student
group by 学号,姓名
hvaing count(课程号)>=4
select 学号,姓名,avg(成绩) as 平均成绩 from Student group by 学号,姓名 having count(*)>=4
Go
insert into student
select 1,'john','数学系',1,90
union all
select 1,'john','数学系',2,91
union all
select 1,'john','数学系',3,92
union all
select 1,'john','数学系',4,93select 学号,姓名,系名,AVG([成绩]) as [平均成绩]
from student
group by 学号,姓名,系名 having COUNT([课程号]) >=4