WITH tmp(ORDER_NO, SLIP_COMMENT, v) AS (
SELECT ORDERS.ORDER_NO,ORDERS.SLIP_COMMENT, sv.value AS v
FROM ORDERS
LEFT JOIN json_each(
    '["'
    || replace(replace(replace(
            ORDERS.SLIP_COMMENT,
            '\', '\\'),
            '"', '\"'),
            ',', '","')
    || '"]'
) as sv
)
SELECT
  ORDER_NO AS OD_NO,
  SLIP_COMMENT AS COMMENT,
  count(v) AS CNT
FROM
  tmp
GROUP BY
  OD_NO, COMMENT
ORDER BY
  CNT DESC,
  OD_NO DESC