select i.ITEM_CODE as CODE,
i.ITEM_NAME as NAME,
sum(UNITPRICE * ORDER_QTY) as TOTAL_AMT
-- select *
from ORDERS o
LEFT JOIN ORDERS_DTL od on o.ORDER_NO = od.ORDER_NO and o.ORDER_DATE between '2023-05-14' and '2023-05-20'
LEFT JOIN ITEM i on od.ITEM_CODE = i.ITEM_CODE
group by CODE
order by TOTAL_AMT desc, CODE
limit 5
;