WITH AGG AS (
  SELECT
    TOTAL_VALUE,
    rowid
  FROM
    CONVENIENCE
  WHERE
    SURVEY_YEAR = 2019
    AND KIND_CODE = '100'
    AND TOTAL_VALUE <> 0
  ORDER BY
    TOTAL_VALUE
), NUMAGG AS (
  SELECT
    TOTAL_VALUE,
    (
      SELECT
        COUNT(*)
      FROM
        AGG
      WHERE
        (TOTAL_VALUE, rowid) <= (z.TOTAL_VALUE, z.rowid)
    ) AS id
  FROM
    AGG AS z
)

SELECT
  ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
  NUMAGG
WHERE
  ID IN (
    SELECT
      MAX(id) / 2
    FROM
      NUMAGG
  )
  OR ID IN (
    SELECT
      CASE WHEN MAX(id) % 2 == 0 THEN MAX(id) / 2 ELSE MAX(id) / 2 + 1 END
    FROM
      NUMAGG
  )