SELECT od.ITEM_CODE AS CODE, i.ITEM_NAME AS NAME, SUM((od.UNITPRICE * od.ORDER_QTY)) AS TOTAL_AMT
    FROM ORDERS_DTL od JOIN ORDERS o ON od.ORDER_NO == o.ORDER_NO JOIN ITEM i ON od.ITEM_CODE == i.ITEM_CODE
    WHERE  o.ORDER_DATE >= "2023-05-14" AND o.ORDER_DATE <= "2023-05-20"
    GROUP BY 1, 2
    ORDER BY 3 DESC, 1 DESC
    LIMIT 5;