select
I.ITEM_CODE as CODE
,I.ITEM_NAME as NAME
,SUM(OD.UNITPRICE * OD.ORDER_QTY) as TOTAL_AMT
from
ITEM I
inner join ORDERS_DTL OD
on I.ITEM_CODE = OD.ITEM_CODE
inner join ORDERS O 
on O.ORDER_NO = OD.ORDER_NO
where
-- 受注日(ORDER_DATE)が、2023年5月14日から2023年5月20日
date(O.ORDER_DATE) >= date('2023-05-14')
and
date(O.ORDER_DATE) <= date('2023-05-20')
group by 1,2
order by 3 desc, 1 desc
limit 5