select
    d.ITEM_CODE as CODE
  , i.ITEM_NAME as NAME
  , sum(d.UNITPRICE) * sum(d.ORDER_QTY) as TOTAL_AMT
from
               ORDERS     o
    inner join ORDERS_DTL d using(ORDER_NO)
    inner join ITEM       i using(ITEM_CODE)
where
    '2023-05-14' <= ORDER_DATE <= '2023-05-20'
group by
    d.ITEM_CODE
order by
    3 desc
  , 1 asc
limit 5
;