select
orders_dtl.ITEM_CODE as CODE
, ITEM.ITEM_NAME as NAME
, orders_dtl.unitprice * orders_dtl.ORDER_QTY as TOTAL_AMT
from ORDERS
inner join orders_dtl on ORDERS.order_no = orders_dtl.order_no
inner join ITEM on orders_dtl.item_code = ITEM.item_code
where date(ORDERS.ORDER_DATE) BETWEEN date('2023-05-14') AND date('2023-05-20')
group by orders_dtl.ITEM_CODE
order by (orders_dtl.unitprice * orders_dtl.ORDER_QTY) desc
, orders_dtl.ITEM_CODE desc
LIMIT 5;