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