select
dtl.ITEM_CODE as CODE,
it.ITEM_NAME as NAME,
sum(dtl.UNITPRICE * dtl.ORDER_QTY) as TOTAL_AMT

from
ORDERS_DTL as dtl
inner join ORDERS as ord
on dtl.ORDER_NO = ord.ORDER_NO
inner join ITEM as it
on dtl.ITEM_CODE = it.ITEM_CODE

where
-- between A and B 日付は””でくくる
ord.ORDER_DATE between "2023-05-14" and "2023-05-20"

group by CODE

order by 
TOTAL_AMT desc, CODE desc

limit 5;
-- できた！天才だ・・・！