select OD.ITEM_CODE as CODE
      ,I.ITEM_NAME as NAME
      ,SUM(OD.UNITPRICE * OD.ORDER_QTY) as TOTAL_AMT
  from ORDERS O
 inner join ORDERS_DTL OD
    on O.ORDER_NO = OD.ORDER_NO
 inner join ITEM I
    on OD.ITEM_CODE = I.ITEM_CODE
 where O.ORDER_DATE between '2023-05-14' and '2023-05-20'
 group by OD.ITEM_CODE, I.ITEM_NAME
 order by TOTAL_AMT desc, CODE desc
;