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