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