SELECT
IT.ITEM_CODE CODE,
IT.ITEM_NAME NAME,
SUM(OD.UNITPRICE * OD.ORDER_QTY) AS TOTAL_AMT
FROM    ORDERS_DTL OD
JOIN    ITEM IT ON OD.ITEM_CODE = IT.ITEM_CODE
JOIN    ORDERS ON   OD.ORDER_NO = ORDERS.ORDER_NO
WHERE   ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY OD.ITEM_CODE,IT.ITEM_NAME
ORDER BY TOTAL_AMT DESC,IT.ITEM_CODE
LIMIT 5;