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