MySQL – SUM by Date

SELECT DATE(date) as date, ROUND(SUM(net), 2) as total_net
FROM paypal_2023
WHERE Item_ID IS NOT NULL AND Item_ID != ''
AND MONTH(date) = 10
GROUP BY DATE(date);