SELECT
C.ITEM_CODE  CODE
,C.ITEM_NAME NAME
,SUM(A.UNITPRICE*A.ORDER_QTY) TOTAL_AMT
FROM
    ORDERS_DTL A
    INNER JOIN ORDERS B
        ON A.ORDER_NO =B.ORDER_NO
    INNER JOIN ITEM C
        ON A.ITEM_CODE= C.ITEM_CODE
WHERE
    B.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY C.ITEM_CODE
order BY 3 DESC
LIMIT 5;