例子:
select 
SUM(case when is_deleted='Y' then price else 0 end) as total_of_deleted_item_price,
SUM(case when is_deleted='N' then price else 0 end) as total_of_item_price,
cust_id
from order group by cust_id