sql server Compute、Compute by

select *
from A
where 数量>8
compute max(数量),min(数量),avg(数量)

select *
from A
where 数量>8
order by 类别
compute max(数量),min(数量),avg(数量) by 类别