求人帮忙一个菜鸟问题

Question

select code,pname,model,formplace,sum(quantity) 
from tb
group by code,pname,model,formplace
order by code

Answer 1

select code,sum(quantity) from tb group by code

Answer 2

select code,min(pname) as pname,min(model) as model,min(formplace) formplace,sum(quantity) as sum_quantity
from tb
group by code
order by code

Answer 3

selec code,pname,model,fromplace,sum(quantity) from tb 
group by code
order by code

Answer 4

select code,sum(quantity) from tb group by code order by code