select IT.ITEM_CODE as CODE , IT.ITEM_NAME as NAME , OD.UNITPRICE * OD.ORDER_QTY as TOTAL_AMT
from ORDERS_DTL as OD
inner join ITEM as IT on IT.ITEM_CODE = OD.ITEM_CODE
inner join ORDERS on OD.ORDER_NO = ORDERS.ORDER_NO
group by IT.ITEM_NAME
Having ORDERS.ORDER_DATE between '2023-05-14' and '2023-05-20'
order by TOTAL_AMT desc , CODE desc;