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