SELECT 
	ITEM.ITEM_CODE AS CODE,
	ITEM.ITEM_NAME AS NAME,
    SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) AS TOTAL_AMT

FROM
    ORDERS
    INNER JOIN ORDERS_DTL
        ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO

    INNER JOIN ITEM
        ON ORDERS_DTL.ITEM_CODE  = ITEM.ITEM_CODE 
        
WHERE
    ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20' 

GROUP BY
    ITEM.ITEM_CODE
    
ORDER BY
    TOTAL_AMT  DESC,
    ORDERS_DTL.ITEM_CODE ASC LIMIT 5;