WITH order_info AS (

    SELECT ITEM_CODE
          ,SUM(UNITPRICE*ORDER_QTY) AS TOTAL_AMT
          FROM ORDERS_DTL AS a
          JOIN ORDERS AS b
          ON a.ORDER_NO = b.ORDER_NO
         WHERE ORDER_DATE BETWEEN DATE('2023-05-14') AND DATE('2023-05-20')
         GROUP BY ITEM_CODE

)
SELECT a.ITEM_CODE AS CODE
      ,ITEM_NAME AS NAME
      ,TOTAL_AMT
  FROM order_info AS a
  JOIN ITEM AS b
    ON a.ITEM_CODE = b.ITEM_CODE
    ORDER BY TOTAL_AMT DESC, CODE DESC
    LIMIT 5