--select ORDER_NO FROM ORDERS WHERE ORDER_DATE >= '2023-05-14' AND ORDER_DATE <= '2023/05/20'
--select * FROM ORDERS_DTL
select TOTAL.ITEM_CODE as CODE, I.ITEM_NAME as NAME, TOTAL.TOTAL_AMT FROM ITEM I, 
(select ITEM_CODE, SUM(UNITPRICE*ORDER_QTY) as TOTAL_AMT
FROM ORDERS_DTL DTL INNER JOIN (select ORDER_NO FROM ORDERS WHERE ORDER_DATE >= '2023-05-14' AND ORDER_DATE <= '2023/05/20') B ON DTL.ORDER_NO=B.ORDER_NO
group by ITEM_CODE ) TOTAL
WHERE I.ITEM_CODE=TOTAL.ITEM_CODE
order by TOTAL_AMT desc, CODE desc;