SELECT CODE
      ,NAME
      ,TOTAL_AMT
FROM (
    SELECT D.*
          ,ROW_NUMBER() OVER(ORDER BY TOTAL_AMT DESC, CODE DESC) 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  date(A.ORDER_DATE) >= date('2023-05-14')
        AND date(A.ORDER_DATE) <= date('2023-05-20')
        GROUP BY B.ITEM_CODE
                ,C.ITEM_NAME
        ) D 
    ) 
WHERE NUM <= 5
ORDER BY TOTAL_AMT DESC
         ,CODE DESC