Toolske.com

SELECT o.order_id, o.order_date, SUM(oi.price) AS total_revenue

FROM orders o

INNER JOIN order_items oi

ON o.order_id = oi.order_id

WHERE o.order_date BETWEEN '2023-05-01' AND '2023-05-31'

GROUP BY o.order_id

ORDER BY total_revenue DESC