Select
 ORDERS_DTL.ITEM_CODE as CODE,
 ITEM.ITEM_NAME as NAME,
 sum(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
From 
 ORDERS_DTL
 left outer join ORDERS on ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
 left outer join ITEM on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
Where
 ORDERS.ORDER_DATE >= '2023-05-14'and
 ORDERS.ORDER_DATE <= '2023-05-20'
Group by
 ORDERS_DTL.ITEM_CODE
Order by
 TOTAL_AMT desc,
 CODE desc
Limit 5;