问使用高级group by编写查询

EN

select case when Seniority between 0 and 5 then '0-5' 
            when Seniority between 6 and 10 then '6-10' 
            ..
       End,
       Avg(outcome)
From yourtable
Group by case when Seniority between 0 and 5 then '0-5' 
            when Seniority between 6 and 10 then '6-10' 
            ..
         End
 Having count(1)>=3

select floor(seniority / 5), avg(outcome)
from t
group by floor(seniority / 5)
having count(*) >= 3;

create table intervals
(
    id int identity(1, 1),
    start int,
    end int
)

insert into intervals values
(0, 5),
(6, 10)
...


select i.id, avg(t.outcome) as outcome
from intervals i
join tablename t on t.seniority between i.start and i.end
group by i.id
having count(*) >=3

;with intervals as(
                    select * from 
                    (values
                            (0, 5),
                            (6, 10)
                            --...
                    ) t(start, [end])
                  )
select i.id, avg(t.outcome) as outcome
from intervals i
join tablename t on t.seniority between i.start and i.[end]
group by i.id
having count(*) >=3