SELECT SUM(d_totalorder) as total, d_st_id, DATE_FORMAT(d_orderdate, '%d') as date
FROM `discounted`
WHERE DATE_FORMAT(d_orderdate, '%Y-%m-%d') BETWEEN '2024-09-01' AND '2024-09-30'
AND d_order_status IN (3,5,6) AND d_sales_type='1'
AND d_mosapp_onumber!='0'
GROUP BY d_st_id, d_orderdate
Commission Scheme
