SELECT CODE,NAME,SUM(TOTAL_AMT) TOTAL_AMT
FROM (

SELECT 
ITM.ITEM_CODE as CODE,
ITM.ITEM_NAME as NAME,
(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from ORDERS ODR
INNER JOIN ORDERS_DTL ODT
ON ODR.ORDER_NO = ODT.ORDER_NO

INNER JOIN ITEM ITM
ON ODT.ITEM_CODE = ITM.ITEM_CODE

WHERE ODR.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
)
GROUP BY CODE,NAME

ORDER BY TOTAL_AMT desc,CODE desc
LIMIT 5