SELECT * FROM (
SELECT
  c.ITEM_CODE AS CODE,
  d.ITEM_NAME AS NAME,
  c.TOTAL_AMT AS TOTAL_AMT
FROM (
    SELECT
      b.ITEM_CODE AS ITEM_CODE,
      SUM(b.UNITPRICE * b.ORDER_QTY) AS TOTAL_AMT
    FROM
      ORDERS AS a
    LEFT JOIN
      ORDERS_DTL AS b
    ON
      a.ORDER_NO = b.ORDER_NO
    WHERE
      a.ORDER_DATE >= "2023-05-14"
      AND a.ORDER_DATE <= "2023-05-20"
    GROUP BY
      ITEM_CODE
) AS c
LEFT JOIN
  ITEM AS d
ON
  c.ITEM_CODE = d.ITEM_CODE
ORDER BY
  TOTAL_AMT DESC,
  CODE DESC
)
LIMIT 5