SELECT DTL.ITEM_CODE CODE, ITEM.ITEM_NAME NAME, SUM(DTL.UNITPRICE * DTL.ORDER_QTY) TOTAL_AMT
FROM ORDERS 
    LEFT JOIN ORDERS_DTL DTL
        ON ORDERS.ORDER_NO = DTL.ORDER_NO
    LEFT JOIN ITEM
        ON DTL.ITEM_CODE = ITEM.ITEM_CODE
WHERE '2023-05-14' <= ORDERS.ORDER_DATE AND ORDERS.ORDER_DATE <= '2023-05-20'
GROUP BY CODE, NAME
ORDER BY TOTAL_AMT DESC, CODE DESC
LIMIT 5