text: SELECT
    c1.concept_id                                                          AS concept_id,
    c1.concept_name                                                        AS concept_name,
    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
    CAST(num_stratum_2 AS INT)                                             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_1000_pp --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 = 704
                      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 @vocab_database_schema.concept c1
  ON CAST(num_stratum_1 AS INT) = c1.concept_id
  INNER JOIN @vocab_database_schema.concept c2
  ON CAST(num_stratum_3 AS INT) = c2.concept_id
  WHERE c1.concept_id = @conceptId
  