SELECT
    ITEM.ITEM_CODE as CODE,
    ITEM.ITEM_NAME as NAME,
    SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
FROM
    ORDERS
    JOIN 
        ORDERS_DTL
        ON
             ORDERS.ORDER_NO == ORDERS_DTL.ORDER_NO
    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, 
    ITEM.ITEM_NAME
ORDER BY
    TOTAL_AMT DESC,
    CODE ASC
    LIMIT 5