text: SELECT c1.concept_id AS concept_id,
  	c1.concept_name as concept_name,
  	concat_ws('-', cast(CAST(num_stratum_4 AS INT) * 10 AS VARCHAR), cast((CAST(num_stratum_4 AS INT) + 1) * 10 - 1 AS VARCHAR)) AS trellis_name, --age decile
  	c2.concept_name AS series_name,  --gender
  	num_stratum_2 AS x_calendar_year, -- calendar year, note, there could be blanks
  	ROUND(1000 * (1.0 * num_count_value / denom_count_value), 5) AS y_prevalence_1000pp --prevalence, per 1000 persons
  FROM (
  	SELECT num.stratum_1 AS num_stratum_1,
  		num.stratum_2 AS num_stratum_2,
  		num.stratum_3 AS num_stratum_3,
  		num.stratum_4 AS num_stratum_4,
  		num.count_value AS num_count_value,
  		denom.count_value AS denom_count_value
  	FROM (
  		SELECT *
  		FROM @results_database_schema.ACHILLES_results
  		WHERE analysis_id = 1804
  			AND stratum_3 IN ('8507', '8532')
  		) num
  	INNER JOIN (
  		SELECT *
  		FROM @results_database_schema.ACHILLES_results
  		WHERE analysis_id = 116
  			AND stratum_2 IN ('8507', '8532')
  		) denom
  		ON num.stratum_2 = denom.stratum_1
  			AND num.stratum_3 = denom.stratum_2
  			AND num.stratum_4 = denom.stratum_3
  	) tmp
  INNER JOIN @cdm_database_schema.concept c1
  	ON num_stratum_1 = CAST(c1.concept_id as VARCHAR)
  INNER JOIN @cdm_database_schema.concept c2
  	ON num_stratum_3 = CAST(c2.concept_id as VARCHAR)
  
  