select SUM(amount*qty)from order_headerwhere status_id in(select status_id from statuswhere status_name in ('派单','送出','结账'))group by order_date;