SELECT CODE
      ,NAME
      ,TOTAL_AMT
FROM (
    SELECT D.*
          ,ROW_NUMBER() OVER(ORDER BY TOTAL_AMT DESC, CODE) NUM
    FROM (
        SELECT B.ITEM_CODE CODE
              ,C.ITEM_NAME NAME
              ,SUM(UNITPRICE *ORDER_QTY) TOTAL_AMT
        FROM ORDERS A
        JOIN ORDERS_DTL B ON A.ORDER_NO =B.ORDER_NO
        LEFT JOIN ITEM C ON B.ITEM_CODE = C.ITEM_CODE
        WHERE '2023/05/14'>= A.ORDER_DATE
        AND A.ORDER_DATE <= '2023/05/20'
        GROUP BY B.ITEM_CODE
                ,C.ITEM_NAME
        ) D 
    ) 
WHERE NUM <= 5
ORDER BY TOTAL_AMT DESC
         ,CODE