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