Co$.vv$

Execute

Sales Data Query

SELECT

otbl.order$\_$id AS 'Order ID$\text{'},$

otbl.order$\_$date AS 'Order Date', otbl.order$\_$total$\_$revenue AS 'Revenue', SUM$($oltbl$.$quantity$)$ AS 'Volume'

FROM

orders otbl

INNER JOIN

inner join order$\_$line$\_$item olitbl ON otbl.order$\_$id $=$ olitbl.order$\_$id

WHERE

otble.order$\_$date between $\text{'}2022-01-01\text{'}$ and $\text{'}2023-1$

GROUP BY

otbl.order$\_$id AS 'Order ID$\text{'},$

otbl.order$\_$date AS 'Order Date',

otbl.order$\_$total$\_$revenue AS 'Revenue',