with target as (
    SELECT
      *
    FROM
      CONVENIENCE
    WHERE
      SURVEY_YEAR = '2019'
      AND KIND_CODE = '100'
)
SELECT
  ROUND(AVG(TOTAL_VALUE)) as SA_MEDIAN
FROM
  (
    SELECT
      TOTAL_VALUE
    FROM
      target
    ORDER BY TOTAL_VALUE
    LIMIT 2 - (SELECT COUNT(*) FROM target) % 2
    OFFSET (SELECT (COUNT(*) - 1) / 2 FROM target)
  );