select
ITEM_CODE   as CODE,
ITEM_NAME   as NAME,
SUM(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from ORDERS_DTL
LEFT JOIN ORDERS USING (ORDER_NO)
LEFT JOIN ITEM USING (ITEM_CODE )
where
ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
group by
ITEM_CODE, ITEM_NAME
order by
SUM(UNITPRICE * ORDER_QTY) DESC,
ITEM_CODE DESC
LIMIT 5