--This SQL script produces a table for the statistic of interest with the defined Get Data Out groups for Sarcomas. --Run on CASREF01 --Sarcoma tumour cohort for GDO tumour_cohort_sarcoma as ( select att.tumourid , diagnosisyear , site_icdo3rev2011_3char , age , morphological_subgroup , sarcoma_group from av2017.at_tumour_england att left join av2017.at_tumour_experimental_england attex on att.tumourid = attex.tumourid inner join analysisandrewbacon.sarcoma_lookup_icdo3_rev11 sarc --- join the lookup on site/morph/behaviour in ICD-O-3 Rev 2011 --- These fields only complete for 2013 onwards on sarc.morphology_code = attex.morph_icdo3rev2011 and sarc.site_code = attex.site_icdo3rev2011_3char and sarc.behaviour_code = attex.behaviour_icdo3rev2011 where diagnosisyear between 2013 and 2017 and ctry_code ='E' -- England residents using country code and STATUSOFREGISTRATION ='F' -- Finalised cases and dedup_flag=1 -- Excluding duplicates, note quality issue in text above and age between 0 and 200 -- Sensible age and sex in (1,2) -- Known sex -- Variation from CAS-SOP #1 : DO NOT EXCLUDE C44 or D codes, these are real sarcomas! --- SEX EXCLUSION FOR C-CODES and ((sex = '2' and site_ICD10_O2_3char not in ('C60','C61','C62','C63')) or (sex = '1' and site_ICD10_O2_3char not in ('C51','C52','C53','C54','C55','C56','C57','C58'))) -- Sex doesn’t agree tumour site ---- SEX EXCLUSION FOR D-CODES and ((sex = '2' and ((site_ICD10_O2_3char not in ('D29','D40')) AND (site_ICD10_O2 not in ('D074','D075','D076')))) -- exclude male D-code tumours for females or (sex = '1' and ((site_ICD10_O2_3char not in ('D06','D25','D26','D27','D28','D39')) AND (site_ICD10_O2 not in ('D070','D071','D072','D073'))))) -- exclude female D-code tumours for males ) , statisticofinterest_sarcoma as (select tumourid, 1 as statisticofinterest_sarcoma from tumour_cohort_sarcoma), tumour_cohort_linked_sarcoma AS ( SELECT * FROM tumour_cohort_sarcoma tc_sarcoma LEFT JOIN statisticofinterest_sarcoma ON statisticofinterest_sarcoma.tumourid = tc_sarcoma.tumourid LEFT JOIN ANALYSISCHARLIETURNER.ages ON ANALYSISCHARLIETURNER.ages.AGE = tc_sarcoma.AGE LEFT JOIN ANALYSISCHARLIETURNER.GDO_gist_site ON ANALYSISCHARLIETURNER.GDO_gist_site.SITE_ICDO3REV2011_3CHAR = tc_sarcoma.SITE_ICDO3REV2011_3CHAR) , extractpartition_sarcoma as ( SELECT '2013' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2013' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2013' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2013' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2014' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2014' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2014' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2014' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2015' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2015' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2015' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2015' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2016' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2016' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2016' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2016' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2017' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2017' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2017' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR = '2017' AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2013-2015' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2013-2015' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2014-2016' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2014-2016' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' UNION ALL SELECT '2015-2017' AS "Year", 'All' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Bone tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Bone tumours of intermediate behaviour' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Chondrosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chondrosarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Chordoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Chordoma' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Ewing sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Ewing sarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Osteosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Osteosarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'Bone' AS "Tumour Type", 'Other malignant bone tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'Bone' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant bone tumours' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'All' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Dermatofibrosarcoma protuberans' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Dermatofibrosarcoma protuberans' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Endometrial stromal sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Endometrial stromal sarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Other' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Other' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Small intestine' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Small intestine' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Gastrointestinal stromal sarcoma (GIST)' AS "Tumour Type 2", 'Stomach' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Gastrointestinal stromal sarcoma (GIST)' AND GDO_GIST_SITE = 'Stomach' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-49' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 00-49' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 50-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 50-59' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Leiomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Leiomyosarcoma' AND SPLIT_50_TO_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Liposarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Liposarcoma' AND SPLIT_60_70 = 'Age 70+' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Malignant peripheral nerve sheath tumour (MPNST)' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Malignant peripheral nerve sheath tumour (MPNST)' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Myofibrosarcomas and other fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myofibrosarcomas and other fibroblastic sarcomas' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Myxoid fibroblastic sarcomas' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Myxoid fibroblastic sarcomas' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 60-79' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Other malignant soft tissue tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Other malignant soft tissue tumours' AND SPLIT_60_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Phyllodes' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Phyllodes' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Rhabdomyosarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Rhabdomyosarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Soft tissue tumours of intermediate behaviour' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Soft tissue tumours of intermediate behaviour' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Synovial' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Synovial' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Tumours of uncertain differentiation' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Tumours of uncertain differentiation' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 00-59' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 00-59' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 60-69' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 60-69' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 70-79' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 70-79' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Undifferentiated Sarcoma' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'Age 80+' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Undifferentiated Sarcoma' AND SPLIT_60_TO_80 = 'Age 80+' UNION ALL SELECT '2015-2017' AS "Year", 'STS' AS "Tumour Type", 'Vascular Tumours' AS "Tumour Type 2", 'All' AS "Tumour Type 3", 'All' AS "Age", SUM(statisticofinterest_sarcoma) as statistic_of_interest FROM tumour_cohort_linked_sarcoma WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 AND SARCOMA_GROUP = 'STS' AND MORPHOLOGICAL_SUBGROUP = 'Vascular Tumours' ) , lsoatoregionlookup as ( select distinct lsoa11, nhser17nm as Region from nspl_201805 left outer join ANALYSISNCR.CCG18_NHSER17_18_LKP_DATALAKE nr on nspl_201805.ccg = nr.ccgapr18cd where substr(lsoa11,1,1) = 'E' ) , lsoatoalllookup as ( select distinct lsoa11, 'All' as Region from nspl_201805 where substr(lsoa11,1,1) = 'E' ) , geoglookup as (select * from lsoatoregionlookup union select * from lsoatoalllookup) /* reminding myself how dual works: select rownum from dual; select rownum from dual -- LAST YEAR NEEDED connect by level <= 3; */ ,sexlookup as ( select 1 as basesex, '1' as sex from dual union select 2 as basesex, '2' as sex from dual union select 1 as basesex, 'All' as sex from dual union select 2 as basesex, 'All' as sex from dual ) -- year look up -- This is hacky, there must be a better way? -- But it does produce a look up table for 2013-2017 -- and also the three year rolling groups for 2013-2017 ,yearlookup as ( select n as baseyear , to_char(n) as year from ( select rownum n from dual -- LAST YEAR NEEDED connect by level <= 2017 ) -- FIRST YEAR NEEDED where n >= 2013 UNION select n as baseyear , '2013-2015' as year from ( select rownum n from dual -- LAST YEAR NEEDED connect by level <= 2015 ) -- FIRST YEAR NEEDED where n >= 2013 UNION select n as baseyear , '2014-2016' as year from ( select rownum n from dual -- LAST YEAR NEEDED connect by level <= 2016 ) -- FIRST YEAR NEEDED where n >= 2014 UNION select n as baseyear , '2015-2017' as year from ( select rownum n from dual -- LAST YEAR NEEDED connect by level <= 2017 ) -- FIRST YEAR NEEDED where n >= 2015 ) -- Making age lookup. --select * from analysischarlieturner.ages; -- We don't have a systematic 'we definitely used this age partition' -- So we should assume any age partition in the age table could be being used. -- There are currently 30 age partitions. -- This is a bit tedious. -- You can at least get a list of them: /* select COLUMN_NAME from ALL_TAB_COLUMNS where owner = 'ANALYSISCHARLIETURNER' and TABLE_NAME = 'AGES' order by COLUMN_NAME; */ -- If I had grip, I would write some R to automate creating this table -- Instead I did it in Excel , agelookup as ( select distinct floor(AGES.AGE/5)+1 as baseage, 'All' as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_13_25_40_60_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_30_50_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_40 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_50_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_50_70_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_TO_40 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_TO_90 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25_40_60 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25_40_60_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25_40_TO_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25_50 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50_70_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_TO_50 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_TO_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_35 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_40 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_40_TO_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_5_THEN_10 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_70_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_TO_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_TO_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_5_10_20_30_50_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_70_75_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_TO_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70_75_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_80 as age from analysischarlieturner.ages UNION select distinct floor(AGES.AGE/5)+1 as baseage, TENYEARAGE as age from analysischarlieturner.ages) -- So, I have a region lookup, a sex lookup, a year lookup, and an age lookup. -- We have no joins for the Welsh LSOAs and for the years before 2013. -- But that is what we wanted -- All ages and sexs have joined to something. , population_table as ( select g.region, s.sex, y.year, a.age, sum(popcount) as popcount from ons2017.populations_normalised POPS left outer join geoglookup g on pops.lsoa11 = g.lsoa11 left outer join sexlookup s on pops.sex = s.basesex left outer join yearlookup y on pops.year = y.baseyear left outer join agelookup a on pops.quinaryagegroupint = a.baseage group by g.region, s.sex, y.year, a.age ) , sarcoma as( SELECT 'Sarcoma' AS "Cancer Site", "Year" AS "Year", "Tumour Type" AS "Tumour Type", "Tumour Type 2" AS "Tumour Type 2", "Tumour Type 3" AS "Tumour Type 3", 'All' AS "Basis of Diagnosis", 'All stages' AS "Stage", 'Not split by stage detail' AS "Stage detail", 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", pops.popcount as "Population" from extractpartition_sarcoma ep left outer join population_table pops on ep."Year" = pops.year and ep."Age" = pops.age where pops.region ='All' and pops.sex='All' ) select * from sarcoma;