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