특정 컬럼 전체 SUM

 

select sum(b2b_order.opt1), sum(b2b_order.opt2), sum(b2b_order.total_price) from b2b_order 
inner join b2b_member on b2b_order.mem_id = b2b_member.mem_id where 1=1  
and b2b_order.status <> 0  
and convert(char(10), b2b_order.buy_date, 120) between '2017-01-01' and '2017-01-31'