SELECT BASE.ITEM_CODE AS CODE,
       IT.ITEM_NAME AS NAME,
       BASE.TOTAL_AMT
  FROM (SELECT ITEM_CODE,
               SUM(UNITPRICE * ORDER_QTY) AS TOTAL_AMT
          FROM ORDERS T1 INNER JOIN ORDERS_DTL T2
                            ON T1.ORDER_NO = T2.ORDER_NO 
          WHERE ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
          GROUP BY ITEM_CODE
          ORDER BY TOTAL_AMT DESC,ITEM_CODE DESC LIMIT 5
        ) BASE INNER JOIN ITEM IT
                  ON BASE.ITEM_CODE = IT.ITEM_CODE