SELECT 
ot.ITEM_CODE AS CODE
,it.ITEM_NAME AS NAME
,
SUM(UNITPRICE * ORDER_QTY) AS TOTAL_AMT
FROM ORDERS od
INNER JOIN ORDERS_DTL ot
ON od.ORDER_NO = ot.ORDER_NO
LEFT OUTER JOIN ITEM it
ON ot.ITEM_CODE = it.ITEM_CODE

WHERE

od.ORDER_DATE
BETWEEN
'2023-05-14'
AND
'2023-05-20'

GROUP BY
ot.ITEM_CODE
,it.ITEM_NAME

ORDER BY
SUM(UNITPRICE * ORDER_QTY) DESC
,it.ITEM_CODE DESC

LIMIT 5
;