SELECT BASE.ITEM_CODE AS CODE,
       IT.ITEM_NAME AS NAME,
       BASE.TOTAL_AMT AS 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
        ) BASE INNER JOIN ITEM IT
                  ON BASE.ITEM_CODE = IT.ITEM_CODE
ORDER BY TOTAL_AMT DESC, CODE DESC