--This SQL script produces a table for the statistic of interest with the defined Get Data Out groups for Bladder, urethra, renal pelvis and ureter.
 
--Run on CASREF01 

--Bladder cancer cohort for GDO

with tumour_cohort_bladder 
as 
(select
att.tumourid
,case WHEN ((site_icd10_o2_3char = 'C65') or (site_icd10_o2 = 'D411') or (site_icd10_o2 = 'D091' and site_icdo3rev2011_3char = 'C65')) THEN 'Renal Pelvis and Ureter'
     WHEN ((site_icd10_o2_3char = 'C66') or (site_icd10_o2 = 'D412') or (site_icd10_o2 = 'D091' and site_icdo3rev2011_3char = 'C66')) THEN 'Renal Pelvis and Ureter'
     WHEN ((site_icd10_o2_3char = 'C67') or (site_icd10_o2 in ('D090','D414')) or (site_icd10_o2 = 'D091' and site_icdo3rev2011_3char = 'C67')) THEN 'Bladder'
     WHEN ((site_icd10_o2_3char = 'C68') or (site_icd10_o2 in ('D413','D417','D419')) or (site_icd10_o2 = 'D091' and site_icdo3rev2011_3char = 'C68')) THEN 'Urethra'
     -- We put TCCs/urothelial of Kidney into Renal Pelvis group (cross-check   Kidney sql!)
     WHEN  ((SITE_ICD10_O2_3CHAR = 'C64' or SITE_ICD10_O2 = 'D410' or (SITE_ICD10_O2 = 'D091' and SITE_ICDO3REV2011_3CHAR = 'C64')) and k_morph.cancer_type like 'Transitional cell carcinoma') THEN 'Renal Pelvis and Ureter'
     ELSE 'Fish!' 
     END as TUMOUR_GROUP
, diagnosisyear
, age
, nvl(att.behaviour_icd10_o2,'X') as behaviour_icd10_o2 ---- where behaviour is missing, treat as unknown
, nvl(attex.morph_icdo3rev2011,'8000') as morph_icdo3rev2011 --- where morphology is missing, treat as 8000
, nvl(ATT.GRADE,'GX') AS GRADE ---- where Grade is missing, treat as unknown
---- this bit tries to summarise T-stage and grade into 'risk level' in the appropriate way
---- DO NOT USE RIGHT NOW!
, case when lower(att.T_BEST) = 'a' and att.GRADE = 'G1' then '1 Low'
		when lower(att.T_BEST) = 'a' and att.GRADE = 'G2' then '2 Intermediate'
		when lower(att.T_BEST) = 'a' and att.GRADE = 'G3' then '3 High'
		when lower(att.T_BEST) = 'a' and att.GRADE = 'GX' then 'X Unknown'
		when substr(att.T_BEST,1,1) = '1' then '3 High' 
		else 'Fish!!' end as risk_level
-- T-stage related fields 
, STAGE.musc_inv, STAGE.invasiveness, STAGE.stage_detail
-- n- and m-stage related field (DO NOT USE RIGHT NOW!)
, spread.spread 
FROM AV2017.AT_TUMOUR_ENGLAND att
LEFT JOIN AV2017.AT_TUMOUR_EXPERIMENTAL_ENGLAND attex
ON att.TUMOURID = attex.TUMOURID
-- join the kidney morphology table to grab those TCCs of kidney
left join analysischarlieturner.kidney_morph k_morph
on k_morph.morph_icdo3rev2011 = attex.morph_icdo3rev2011 and k_morph.behaviour_icdo3rev2011 = attex.behaviour_icdo3rev2011
--- join the bladder stages table to get various levels of stage (there is an explanatory version on non-era if needed)
LEFT JOIN analysischarlieturner.BLADDER_STAGES STAGE
ON
CASE WHEN SUBSTR(LOWER(nvl(att.STAGE_BEST,'x')),1,1) IN ('?','u','x','6') then 'x' else substr(lower(att.stage_best),1,1) end = stage.stage_best
and
substr(upper(att.site_icd10_o2),1,1) = stage.site_icd10_o2_1char
and
substr(lower(nvl(att.T_BEST,'x')),1,1) = stage.t_best
--- join my 'spread' table (DO NOT USE RIGHT NOW!)
left join analysischarlieturner.spread 
on substr(nvl(N_BEST,'X'),1,1) = N_BEST_SUMMARY AND substr(nvl(M_BEST,'X'),1,1) = M_BEST_SUMMARY 
WHERE
DIAGNOSISYEAR between 2013 and 2017
--- STANDARD CHECKS LIKE CASSOP # 1
-- Only finals
and statusofregistration = 'F'
-- Only English
and ctry_code = 'E'
-- Only known sex, no sex = 9
and sex in ('1','2')
-- Not duplicates:
and dedup_flag = 1
and age between 0 and 200
and (
    (SITE_ICD10_O2_3CHAR in ('C65','C66','C67','C68'))
    or 
    (SITE_ICD10_O2 in ('D090','D411','D412','D413','D414','D417','D419'))
    or
    (SITE_ICD10_O2 = 'D091' and SITE_ICDO3REV2011_3CHAR in ('C65','C66','C67','C68'))
    or 
    --- adding the TCCs of the Kidney, to go into Renal Pelvis group
    ((SITE_ICD10_O2_3CHAR = 'C64' or SITE_ICD10_O2 = 'D410' or (SITE_ICD10_O2 = 'D091' and SITE_ICDO3REV2011_3CHAR = 'C64')) and k_morph.cancer_type like 'Transitional cell carcinoma'
    )
    )
and --- exclude uncertain behaviour for urethral cancers
	( NOT
	(
	((site_icd10_o2_3char = 'C68') or (site_icd10_o2 in ('D413','D417','D419')) or (site_icd10_o2 = 'D091' and site_icdo3rev2011_3char = 'C68')) AND behaviour_icd10_o2 = 1
	)
	)
)

,
statisticofinterest_bladder as 
(select tumourid, 1 as statisticofinterest_bladder from tumour_cohort_bladder),
tumour_cohort_linked_bladder AS ( SELECT * FROM tumour_cohort_bladder tc_bladder
LEFT JOIN statisticofinterest_bladder ON statisticofinterest_bladder.tumourid = tc_bladder.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = tc_bladder.AGE
LEFT JOIN ANALYSISCHARLIETURNER.behaviour behaviour ON behaviour.BEHAVIOUR_ICD10_O2 = tc_bladder.BEHAVIOUR_ICD10_O2
LEFT JOIN ANALYSISCHARLIETURNER.bladder_morph morph ON morph.MORPH_ICDO3REV2011 = tc_bladder.MORPH_ICDO3REV2011
LEFT JOIN ANALYSISCHARLIETURNER.grades grades ON grades.GRADE = tc_bladder.GRADE)
 
 
 , extractpartition_bladder as ( 

SELECT '2013' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2013' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2013' 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2014' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2014' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2014' 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2015' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2015' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2015' 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2016' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2016' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2016' 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2017' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2017' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR = '2017' 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2013-2015' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2014-2016' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND TUMOUR_GROUP = 'Urethra'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'All' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Other' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Other' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G1' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G1'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G2' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G2'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'G3' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'G3'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'GX' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta' 
AND GRADE_NO4 = 'GX'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'Urothelial' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MORPH_GROUP = 'Urothelial' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Bladder' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Bladder' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'T1' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'T1'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Ta/Tis NOS' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Ta/Tis NOS'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Non-muscle-invasive' AS "Stage", 
 'Ta/Tis' AS "Stage Detail", 
 'Tis' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Non-muscle-invasive' 
AND INVASIVENESS = 'Ta/Tis' 
AND STAGE_DETAIL = 'Tis'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Malignant and in situ' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'Stage unknown' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Malignant and in situ' 
AND MUSC_INV = 'Stage unknown'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Renal Pelvis and Ureter' AS "Tumour Type", 
 'Uncertain or unknown' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Renal Pelvis and Ureter' 
AND BEH_GROUP = 'Uncertain or unknown'

UNION ALL

SELECT '2015-2017' AS "Year", 
 'Urethra' AS "Tumour Type", 
 'All' AS "Tumour Type 2", 
 'All' AS "Tumour Type 3", 
 'All' AS "Stage", 
 'All' AS "Stage Detail", 
 'All' AS "Stage Detail 2", 
 'All' AS "Grade", 
SUM(statisticofinterest_bladder) as statistic_of_interest
FROM tumour_cohort_linked_bladder
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND TUMOUR_GROUP = 'Urethra'
 ) , 
bladder as(
SELECT
'Bladder, Urethra, Renal Pelvis and Ureter' AS "Cancer Site",
"Year" AS "Year",
"Tumour Type" AS "Tumour Type",
"Tumour Type 2" AS "Tumour Type 2",
"Tumour Type 3" AS "Tumour Type 3",
'All' AS "Basis of Diagnosis",
case when "Stage" = 'All' then 'All stages' else "Stage" end AS "Stage",
"Stage Detail" AS "Stage Detail",
"Stage Detail 2" AS "Stage Detail 2",
'All ages' AS "Age",
'All England' AS "Region",
'Persons' AS "Sex",
"Grade" AS "Grade",
'Not split by nodal status' AS "Nodal Status",
statistic_of_interest as "statistic_of_interest"
from extractpartition_bladder 
 )  
 select * from bladder ;