--This SQL script produces a table for the statistic of interest with the defined Get Data Out groups for kidney. --Run on CASREF01 --Kidney tumour cohort for GDO with tumour_cohort_kidney as ( select t.tumourid , t.diagnosisyear , case when substr(site_icd10_o2,1,1) = 'C' then 'Malignant kidney cancer' else 'Kidney tumours of uncertain behaviour' end as tumour_type , nvl(mg.cancer_type,'Renal cell carcinoma NOS') as tumour_type_2 , t.basisofdiagnosis , t.age, t.sex , nvl(t.stage_best,'X') as stage_best from av2017.av_tumour_england t left outer join av2017.av_tumour_experimental_england te on t.tumourid = te.tumourid left outer join ANALYSISCHARLIETURNER.KIDNEY_MORPH mg on mg.morph_icdo3rev2011 = nvl(te.morph_icdo3rev2011,8000) and mg.behaviour_icdo3rev2011 = te.behaviour_icdo3rev2011 where t.ctry_code = 'E' and t.statusofregistration = 'F' and t.dedup_flag=1 and t.age between 0 and 200 and t.sex in (1,2) and t.diagnosisyear between 2013 and 2017 and (t.site_icd10_o2_3char = 'C64' or t.site_icd10_o2 = 'D410' or(t.site_icd10_o2 = 'D091' and te.site_icdo3rev2011_3char = 'C64')) and nvl(mg.cancer_type,'Renal cell NOS') != 'Transitional cell carcinoma' ) , statisticofinterest_kidney as (select tumourid, 1 as statisticofinterest_kidney from tumour_cohort_kidney), tumour_cohort_linked_kidney AS ( SELECT * FROM tumour_cohort_kidney tc_kidney LEFT JOIN statisticofinterest_kidney ON statisticofinterest_kidney.tumourid = tc_kidney.tumourid LEFT JOIN ANALYSISCHARLIETURNER.ages ON ANALYSISCHARLIETURNER.ages.AGE = tc_kidney.AGE LEFT JOIN ANALYSISCHARLIETURNER.stages ON ANALYSISCHARLIETURNER.stages.STAGE_BEST = tc_kidney.STAGE_BEST LEFT JOIN ANALYSISCHARLIETURNER.GDO_basisofdiag ON ANALYSISCHARLIETURNER.GDO_basisofdiag.BASISOFDIAGNOSIS = tc_kidney.BASISOFDIAGNOSIS) , extractpartition_kidney as ( SELECT '2013' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' UNION ALL SELECT '2013' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2013' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2014' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' UNION ALL SELECT '2014' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2014' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2015' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' UNION ALL SELECT '2015' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2015' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2016' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' UNION ALL SELECT '2016' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2016' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2017' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' UNION ALL SELECT '2017' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR = '2017' AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2013-2015' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 UNION ALL SELECT '2013-2015' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2014-2016' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 UNION ALL SELECT '2014-2016' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' UNION ALL SELECT '2015-2017' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 UNION ALL SELECT '2015-2017' AS "Year", 'Kidney tumours of uncertain behaviour' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Kidney tumours of uncertain behaviour' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Chromophobe RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Chromophobe RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 00-49' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 00-49' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 50-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 50-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 3' AND SPLIT_50_70_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 00-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Clear cell RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Clear cell RCC' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Other' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Other' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Papillary RCC' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Papillary RCC' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-59' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 60-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 1-2' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 1-2' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 3' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 3' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage 4' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage 4' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 00-69' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 00-69' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 70-79' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Renal cell carcinoma NOS' AS "Tumour Type 2", 'Not histologically confirmed' AS "Basis of Diagnosis", 'Stage unknown' AS "Stage", 'Age 80+' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Renal cell carcinoma NOS' AND BASISOFDIAG = 'Not histologically confirmed' AND STAGE_SPLIT23 = 'Stage unknown' AND SPLIT_70_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'Malignant kidney cancer' AS "Tumour Type", 'Wilms (Neuroblastoma)' AS "Tumour Type 2", 'All' AS "Basis of Diagnosis", 'All' AS "Stage", 'All' AS "Age", SUM(statisticofinterest_kidney) as statistic_of_interest FROM tumour_cohort_linked_kidney WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND TUMOUR_TYPE = 'Malignant kidney cancer' AND TUMOUR_TYPE_2 = 'Wilms (Neuroblastoma)' ) , kidney as( SELECT 'Kidney' AS "Cancer Site", "Year" AS "Year", "Tumour Type" AS "Tumour Type", "Tumour Type 2" AS "Tumour Type 2", 'All' AS "Tumour Type 3", "Basis of Diagnosis" AS "Basis of Diagnosis", case when "Stage" = 'All' then 'All stages' else "Stage" end AS "Stage", 'Not split by Stage Detail' AS "Stage Detail", 'Not split by Stage Detail 2' AS "Stage Detail 2", case when "Age" = 'All' then 'All ages' else "Age" end AS "Age", 'All England' AS "Region", 'Persons' AS "Sex", 'Not split by grade' AS "Grade", 'Not split by nodal status' AS "Nodal Status", statistic_of_interest as "statistic_of_interest" from extractpartition_kidney ) select * from kidney ;