select  ITEM.ITEM_CODE as CODE,
        ITEM.ITEM_NAME as NAME,
        sum(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
from    ORDERS
join    ORDERS_DTL on ORDERS.ORDER_NO = ORDERS.ORDER_NO
join    ITEM on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where   (ORDERS.ORDER_DATE >= '2023-05-14') and (ORDERS.ORDER_DATE <= '2023-05-20')
group by    CODE,
            NAME
order by    TOTAL_AMT desc,
            CODE desc
limit 5