-- Tables required for this script are
-- ANALYSISCHARLIETURNER.OVARIAN_ALL
-- ANALYSISCHARLIETURNER.stages
-- ANALYSISCHARLIETURNER.ages

/*
Structure of this file.
1. Notes
2. Define tables:
 - 'statisticofinterest' table which refers to the ovarian cohort table OVARIAN_ALL
 - 'pops_and_ages' population counts for years, sexes and ages (brings in the age brackets from the ages table)
 - GDO_Ovarian - This is the 'counting cases' table for ovarian tumours by Year of diagnosis, Tumour Type, stage and age. 
   This table contains some new rows: all rows with 2013-2015 and 2014-2016 were not in the original version from R and should be 
   checked to make sure they are the sum of the relevant years
 - OVARIAN_POPS - This is the 'at-risk population' for the same cohorts as the ovarian tumours, by Year and Age for females only.
3. Join GDO_Ovarian and OVARIAN_POPS

This file contains groups for 2013, 2014, 2015, 2016, 2013-2015, 2014-2016.
*/
/*
NOTES ON THE OVARIAN_POPS TABLE CONSTRUCTION

We can get from AGE to QUINARYAGEGROUPINT via
FLOOR(AGE/5,0)+1

Demographic splits for Ovarian are:
YEAR: 2013, 2014, 2015, 2016, 2013-2015, 2014-2016
AGE: "All", split_30_to_70, split_50_to_70, split_50_to_80, split_60_to_80, split_50, split_70_80
SEX: Female only

Organising the age groups:
We will need only 
split_30_to_70, 
split_50, 
'Age 00-59', 'Age 70-79' and 'Age 80+' from split_60_TO_80, 
'Age 00-69' from split_70_80.
*/

-- the Ovarian tumour cohort is defined over in OVARIAN_ALL
WITH 
statisticofinterest as
(select tumourid, 1 as statisticofinterest from ANALYSISCHARLIETURNER.OVARIAN_ALL),

--- Population and age table for ovarian cancer
pops_and_ages as (
select pops.year, pops.sex, ages.split_30_to_70, ages.split_50, ages.split_60_TO_80, ages.split_70_80, sum(popcount) as popcount from 
ons2016.populations_normalised POPS
left join ANALYSISCHARLIETURNER.ages
--- This is a slightly weird join, but it means we only get one row for age five year age group
on POPS.QUINARYAGEGROUPINT = floor(AGES.AGE/5)+1
where age/5 = floor(age/5)
AND YEAR BETWEEN 2013 AND 2016
and LSOA11 like 'E%'
-- this is an ovarian population table, so only want females
AND pops.sex = 2
group by pops.year, pops.sex, ages.split_30_to_70, ages.split_50, ages.split_60_TO_80, ages.split_70_80
),

GDO_Ovarian AS (
/* Remove this as we are NOT covering "All Years" any more
SELECT 'All' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE


UNION ALL
*/


SELECT '2013' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'

UNION ALL

SELECT '2013' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified'

UNION ALL

SELECT '2013' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'

UNION ALL

SELECT '2013' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'

UNION ALL

SELECT '2013' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Non-specific site'

UNION ALL

SELECT '2013' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell'

UNION ALL

SELECT '2013' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'

UNION ALL

SELECT '2013' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2013' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'

UNION ALL

SELECT '2014' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'

UNION ALL

SELECT '2014' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified'

UNION ALL

SELECT '2014' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'

UNION ALL

SELECT '2014' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'

UNION ALL

SELECT '2014' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Non-specific site'

UNION ALL

SELECT '2014' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell'

UNION ALL

SELECT '2014' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'

UNION ALL

SELECT '2014' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2014' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'

UNION ALL

SELECT '2015' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'

UNION ALL

SELECT '2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified'

UNION ALL

SELECT '2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'

UNION ALL

SELECT '2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'

UNION ALL

SELECT '2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Non-specific site'

UNION ALL

SELECT '2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell'

UNION ALL

SELECT '2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'

UNION ALL

SELECT '2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2015' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'

UNION ALL

SELECT '2016' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'

UNION ALL

SELECT '2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified'

UNION ALL

SELECT '2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'

UNION ALL

SELECT '2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'

UNION ALL

SELECT '2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Non-specific site'

UNION ALL

SELECT '2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell'

UNION ALL

SELECT '2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'

UNION ALL

SELECT '2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR = '2016' 
AND MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL 

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Non-specific site'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'
AND DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL 

SELECT '2014-2016' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL 

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 00-29'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 30-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 30-39'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 40-49'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Borderline' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Borderline' 
AND ages.SPLIT_30_TO_70 = 'Age 70+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 1' AS "Stage",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 1' 
AND ages.SPLIT_50_TO_70 = 'Age 70+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 2-3' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 2-3' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 50-59'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage 4' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage 4' 
AND ages.SPLIT_50_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 00-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 00-59'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 60-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant epithelial' AS "Tumour Type",
 'Stage unknown' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Malignant epithelial' 
AND stages.STAGE_SPLIT14 = 'Stage unknown' 
AND ages.SPLIT_60_TO_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 00-69'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 70-79' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 70-79'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Miscellaneous and unspecified' AS "Tumour Type",
 'All' AS "Stage",
 'Age 80+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Miscellaneous and unspecified' 
AND ages.SPLIT_70_80 = 'Age 80+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-specific site' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Non-specific site'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 00-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 00-49'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Sex cord-stromal and germ cell' AS "Tumour Type",
 'All' AS "Stage",
 'Age 50+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM ANALYSISCHARLIETURNER.OVARIAN_ALL O_ALL
LEFT JOIN statisticofinterest si ON si.tumourid = O_ALL.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.stages stages ON stages.STAGE_BEST = O_ALL.STAGE_BEST
LEFT JOIN ANALYSISCHARLIETURNER.ages ages ON ages.AGE = O_ALL.AGE
WHERE MORPH_CAT_3 = 'Sex cord-stromal and germ cell' 
AND ages.SPLIT_50 = 'Age 50+'
AND DIAGNOSISYEAR BETWEEN 2014 AND 2016),

OVARIAN_POPS AS (
--- Selecting from a table allows us to COALESCE (removing 'null's to be something meaningful
--- AND it allows us to filter out null years, and sort meaningfully when we've finished.
SELECT YEAR, SEX, COALESCE(AGE,'All Ages') as AGE, POPULATION
FROM
(
/*
INDIVIDUAL YEARS SECTION
*/
--- split_30_to_70 for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, split_30_to_70 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
group by cube (year, split_30_to_70)

UNION 

-- split_50 for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, split_50 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
group by year, cube (split_50)

UNION ALL
-- 'Age 00-59' for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, 'Age 00-59' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 00-59'
group by cube (year)

UNION ALL 

-- 'Age 70-79' for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, 'Age 70-79' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 70-79'
group by cube (year)

UNION ALL 

-- 'Age 80+' for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, 'Age 80+' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 80+'
group by cube (year)

UNION ALL 

--- 'Age 00-69' from split_70_80 for each individual year
SELECT CAST(YEAR AS VARCHAR(9)) as year, 'Female' as SEX, 'Age 00-69' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_70_80 like 'Age 00-69'
group by cube (year)

UNION ALL 


/*
2013-2015 section
*/

-- split_30_to_70 for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, split_30_to_70 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and year between 2013 and 2015
group by cube (split_30_to_70) --- USING CUBE gives us the 'All Ages' we need

UNION ALL

-- split_50 for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, split_50 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and year between 2013 and 2015
group by split_50 -- not using CUBE avoids getting an extra 'All Ages' that we don't need

UNION ALL

-- 'Age 00-59' for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, 'Age 00-59' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 00-59'
and year between 2013 and 2015

UNION ALL 

-- 'Age 70-79' for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, 'Age 70-79' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 70-79'
and year between 2013 and 2015

UNION ALL 

-- 'Age 80+' for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, 'Age 80+' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 80+'
and year between 2013 and 2015

UNION ALL 

--- 'Age 00-69' from split_70_80 for 2013-2015
SELECT '2013-2015' as year, 'Female' as SEX, 'Age 00-69' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_70_80 like 'Age 00-69'
and year between 2013 and 2015

UNION ALL
/*
2014-2016 section
*/

-- split_30_to_70 for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, split_30_to_70 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and year between 2014 and 2016
group by cube(split_30_to_70) --- USING CUBE gives us the 'All Ages' we need

UNION ALL

-- split_50 for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, split_50 as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and year between 2014 and 2016
group by split_50 -- not using CUBE avoids getting an extra 'All Ages' that we don't need

UNION ALL

-- 'Age 00-59' for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, 'Age 00-59' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 00-59'
and year between 2014 and 2016

UNION ALL 

-- 'Age 70-79' for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, 'Age 70-79' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 70-79'
and year between 2014 and 2016

UNION ALL 

-- 'Age 80+' for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, 'Age 80+' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_60_to_80 like 'Age 80+'
and year between 2014 and 2016

UNION ALL 

--- 'Age 00-69' from split_70_80 for 2014-2016
SELECT '2014-2016' as year, 'Female' as SEX, 'Age 00-69' as AGE, SUM(POPCOUNT) AS POPULATION
from pops_and_ages
where SEX = 2
and split_70_80 like 'Age 00-69'
and year between 2014 and 2016
)
WHERE year is not null)

select GDO_OVARIAN.*, OVARIAN_POPS.population from GDO_OVARIAN
left outer join OVARIAN_POPS
on GDO_OVARIAN."Year" = OVARIAN_POPS.year
AND ((GDO_OVARIAN."Age" = 'All' AND OVARIAN_POPS.age = 'All Ages') OR
 (GDO_OVARIAN."Age" = OVARIAN_POPS.age))
 
 
order by "Year", "Tumour Type", "Stage", "Age"
 ;