WITH T AS (
    SELECT
        ITEM.ITEM_CODE AS CODE,
        ITEM.ITEM_NAME AS NAME,
        (UNITPRICE * ORDER_QTY) AS TOTAL_AMT,
        RANK() OVER(ORDER BY (UNITPRICE * ORDER_QTY) DESC) AS RNK
    FROM
        ORDERS_DTL
        INNER JOIN
            ITEM ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE,
            ORDERS ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
    WHERE
        (ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20')
)
SELECT
    CODE,
    NAME,
    TOTAL_AMT
FROM
    T
WHERE
    RNK <= 5