SELECT
ITEM_CODE AS CODE
, ITEM_NAME AS NAME
, UNITPRICE*SUM(ORDER_QTY) AS TOTAL_AMT
FROM (
    SELECT
        -- ORDER_NO
        ITEM_CODE
        , ITEM_NAME
        , UNITPRICE
        , ORDER_QTY
    FROM ITEM RIGHT JOIN (
        SELECT 
            -- ORDER_NO
            ITEM_CODE
            , UNITPRICE
            , ORDER_QTY
        FROM ORDERS_DTL RIGHT JOIN (
            SELECT
                ORDER_NO
            FROM ORDERS
            WHERE ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
        )
        USING (ORDER_NO)
    )
    USING (ITEM_CODE)
    -- ORDER BY ORDER_NO
)
GROUP BY ITEM_CODE
ORDER BY UNITPRICE*SUM(ORDER_QTY) DESC, ITEM_CODE DESC
LIMIT 5