SELECT D.ITEM_CODE AS CODE,
       I.ITEM_NAME AS NAME,
       sum(D.UNITPRICE * D.ORDER_QTY) as TOTAL_AMT
        from ORDERS
            inner join
                ORDERS_DTL as D on ORDERS.ORDER_NO=D.ORDER_NO
            inner join
                ITEM as I on D.ITEM_CODE=I.ITEM_CODE
        where ORDERS.ORDER_DATE between '2023-05-14' and '2023-05-20'
    group by CODE
        order by TOTAL_AMT desc, CODE desc
            limit 5;