--受注数量を求める
WITH
wk_ordersum(ITEM_CODE, ITEM_NAME, TOTAL_AMT)
AS
(
 SELECT
  b.ITEM_CODE AS CODE
  ,c.ITEM_NAME AS NAME
  ,SUM(b.UNITPRICE * b.ORDER_QTY) AS TOTAL_AMT
 FROM
  ORDERS a
  inner join
  ORDERS_DTL b
  on a.ORDER_NO = b.ORDER_NO
  inner join
  ITEM c
  on b.ITEM_CODE = c.ITEM_CODE
 WHERE
  a.ORDER_DATE BETWEEN '2023-05-14' and '2023-05-20'
 GROUP BY
  b.ITEM_CODE, c.ITEM_NAME
)
--表示
SELECT
 ITEM_CODE AS CODE
 ,ITEM_NAME AS NAME
 ,TOTAL_AMT
FROM
 wk_ordersum
ORDER BY
 TOTAL_AMT desc
 ,CODE desc