select I.ITEM_CODE as CODE
      ,I.ITEM_NAME as NAME
      ,SUM(SD.UNITPRICE * SD.SALES_QTY) as SAL_AMT
  from SALES S
 inner join SALES_DTL SD
    on S.SALES_NO = SD.SALES_NO
 inner join ITEM I
    on SD.ITEM_CODE = I.ITEM_CODE
 where S.SALES_DATE between '2023-06-01' and '2023-06-30'
 group by I.ITEM_CODE, I.ITEM_NAME
 order by SAL_AMT desc, CODE desc
;