SELECT
     t2.ITEM_CODE AS CODE
    ,t3.ITEM_NAME AS NAME
    ,sum(UNITPRICE * ORDER_QTY) AS TOTAL_AMT
FROM
    ORDERS t1
INNER JOIN ORDERS_DTL t2
ON t1.ORDER_NO = t2.ORDER_NO 

INNER JOIN ITEM t3
ON t2.ITEM_CODE = t3.ITEM_CODE

WHERE
    ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'

GROUP BY t2.ITEM_CODE,t3.ITEM_NAME

ORDER BY 3 DESC,1 DESC
limit 5