求SQL解决平均值语句

Question

          biz_id         price
           1              10
           1              11
           1              10.5           2              51
           2              53           3              60
           3              61
           3              65                         求以BIZ_ID 为组的  PRICE 的平均值! 结果 如:          biz_id         price
           1              10.5
           2               52
           3               62
 谢谢!
        
     
            

Answer 1

select 
  biz_id,
  avg(price) as price
from 
  tb
group by
  biz_id 

Answer 2

select biz_id,avg(price) as 平均值 from tb group by biz_id

Answer 3

if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([biz_id] int,[price] dec(3,1))
insert [tb]
select 1,10 union all
select 1,11 union all
select 1,10.5 union all
select 2,51 union all
select 2,53 union all
select 3,60 union all
select 3,61 union all
select 3,65select 
  biz_id,
  avg(price) as price
from 
  tb
group by
  biz_id 
--测试结果:
/*
biz_id      price
----------- ---------------------------------------
1           10.500000
2           52.000000
3           62.000000(3 行受影响)
*/