SELECT ROUND(AVG(TOTAL_VALUE)) as SA_MEDIAN
FROM (SELECT TOTAL_VALUE
      FROM (
      	select TOTAL_VALUE
	    from CONVENIENCE
	    where SURVEY_YEAR=2019
	    and KIND_CODE='100'
      )
      ORDER BY TOTAL_VALUE
      LIMIT 2 - (SELECT COUNT(*) FROM (
      	select TOTAL_VALUE
	    from CONVENIENCE
	    where SURVEY_YEAR=2019
	    and KIND_CODE='100'
      )) % 2    -- odd 1, even 2
      OFFSET (SELECT (COUNT(*) - 1) / 2
              FROM (
              select TOTAL_VALUE
	    from CONVENIENCE
	    where SURVEY_YEAR=2019
	    and KIND_CODE='100'
              )))