WITH TMP 
AS(
SELECT
    O_DTL.ITEM_CODE AS CODE
    ,O_DTL.UNITPRICE 
    ,O_DTL.ORDER_QTY
    ,SUM(O_DTL.UNITPRICE * O_DTL.ORDER_QTY) AS TOTAL_AMT
FROM
    ORDERS AS O
LEFT JOIN
    ORDERS_DTL AS O_DTL
USING
    (ORDER_NO)
WHERE
    O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY
    O_DTL.ITEM_CODE
)
SELECT 
    T.CODE AS CODE
    ,I.ITEM_NAME AS NAME
    ,T.TOTAL_AMT AS TOTAL_ATM
FROM
    TMP AS T
LEFT JOIN
    ITEM AS I
ON
    T.CODE = I.ITEM_CODE
ORDER BY
    T.TOTAL_AMT DESC
    ,ITEM_CODE DESC
LIMIT 
    5;