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