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 ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '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;