select t1.brand 品牌,
t1.disc as disc,t1.price as price,t1.val as val,t1.qty as qty ,
Convert(decimal(20,2),t1.qty/t3.totalsell_qty*100) as qtypercent,占比1
Convert(decimal(20,2),t1.val/t4.totalsell_val*100) as valpercent 占比2
from (select brand,sum(sell_qty) qty,sum(sell_val) val,Convert(decimal(20,2),Avg(disc_rate)) as disc, Convert(decimal(20,2),Sum(unit_price)) as price from tbl_crm_rlb group by brand ) t1,
(select sum(sell_qty) totalsell_qty from tbl_crm_rlb) t3,
(select sum(sell_val) totalsell_val from tbl_crm_rlb) t4
ORDER BY qtypercent DESC