SELECT
    X.CODE AS CODE,
    X.NAME AS NAME,
    X.TOTAL_AMT AS TOTAL_AMT
FROM (
    SELECT
        C.ITEM_CODE AS CODE,
        C.ITEM_NAME AS NAME,
        SUM(B.UNITPRICE * B.ORDER_QTY) AS TOTAL_AMT,
        RANK() OVER (ORDER BY SUM(B.UNITPRICE * B.ORDER_QTY) DESC, C.ITEM_CODE DESC) AS RANK_NO
    FROM ORDERS A
    INNER JOIN ORDERS_DTL B
    ON A.ORDER_NO = B.ORDER_NO
    INNER JOIN ITEM C
    ON B.ITEM_CODE = C.ITEM_CODE
    WHERE A.ORDER_DATE >= '2023-05-14'
    AND A.ORDER_DATE <= '2023-05-20'
    GROUP BY C.ITEM_CODE, C.ITEM_NAME
    ORDER BY TOTAL_AMT DESC, C.ITEM_CODE DESC
) X
WHERE X.RANK_NO <= 5