-- Tables required for this script are
-- ANALYSISCHARLIETURNER.ages
-- ANALYSISCHARLIETURNER.brain_site

-- This is the data that drives the latest brains partition (as of 2019-05-23, to cover all years 2013-2017)

-- It is run on the av2017 table on CASREF01 (the end of year copy of CAS1902)
-- It currently does incidence counts, but if you change the statistic of interest table it should count other things.


with braindata

as

(

select tumourid
, diagnosisyear
, site_icd10_o2
, age
, nhs_region_2017_name as region
, case
when sex = 1 then 'Male'
when sex = 2 then 'Female'
end as sex
from av2017.av_tumour_england t

where diagnosisyear in ('2013','2014','2015','2016','2017')
-- This is all brains
and (site_icd10_o2_3char in ('C70', 'C71','C72','D43','D42','D33','D32')
OR 
SITE_icd10_o2  IN ('C751', 'C752','C753','D443','D444','D445','D352','D353','D354') )

-- Only finals
and statusofregistration = 'F'
-- Only English
and ctry_code = 'E'

-- Only known sex, no sex = 9
and sex in ('1','2')
-- Not duplicates:
and dedup_flag = 1
and age between 0 and 200 -- Sensible age
)

,
statisticofinterest as
(select tumourid, 1 as statisticofinterest from braindata),
BRAIN_ALL AS ( SELECT * FROM braindata bdata
LEFT JOIN statisticofinterest si ON si.tumourid = bdata.tumourid
LEFT JOIN ANALYSISCHARLIETURNER.ages ON ANALYSISCHARLIETURNER.ages.AGE = bdata.AGE
LEFT JOIN ANALYSISCHARLIETURNER.brain_site ON ANALYSISCHARLIETURNER.brain_site.SITE_ICD10_O2 = bdata.SITE_ICD10_O2)

, extractpartitions
as
(
SELECT '2013' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2013' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2013' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2014' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2014' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2015' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2016' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2016' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2017' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR = '2017' 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2013-2015' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2013 AND 2015 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2014-2016' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2014 AND 2016 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'All' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-39' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 00-39'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 40-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 40-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-59' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 50-59'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 60-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 60-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Benign endocrine' 
AND SPLIT_40_TO_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-04' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 00-04'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 05-09' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 05-09'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 10-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 10-19'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'London'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 30-49' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'London'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 50-69' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'London'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'North Of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Male'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Malignant brain' 
AND SPLIT_5_10_20_30_50_70 = 'Age 70+' 
AND REGION = 'South of England' 
AND SEX = 'Female'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-benign endocrine' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-benign endocrine'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'All' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 00-19' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 00-19'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 20-29' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 20-29'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 30-49' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 30-49'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 50-69' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 50-69'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'All' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'London' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'London' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'Midlands and East of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'Midlands and East of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'North of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'North Of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'All' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Male' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Male' 
AND SPLIT_20_30_50_70 = 'Age 70+'

UNION ALL

SELECT '2015-2017' AS "Year",
 'Non-malignant brain' AS "Tumour Type",
 'South of England' AS "Region",
 'Female' AS "Sex",
 'Age 70+' AS "Age",
SUM(statisticofinterest) as Incidence
FROM BRAIN_ALL
WHERE DIAGNOSISYEAR BETWEEN 2015 AND 2017 
AND SITE_GROUPING = 'Non-malignant brain' 
AND REGION = 'South of England' 
AND SEX = 'Female' 
AND SPLIT_20_30_50_70 = 'Age 70+'
)

, lsoatoregionlookup
as
(
select distinct lsoa11, nhser17nm as Region from nspl_201805
left outer join ANALYSISNCR.CCG18_NHSER17_18_LKP_DATALAKE nr
on nspl_201805.ccg = nr.ccgapr18cd
where substr(lsoa11,1,1) = 'E'
)
, lsoatoalllookup
as
(
select distinct lsoa11, 'All' as Region from nspl_201805
where substr(lsoa11,1,1) = 'E'
)
, geoglookup as 
(select * from lsoatoregionlookup
union
select * from lsoatoalllookup)

/*
reminding myself how dual works:
select rownum from dual;

select rownum  from dual 
 -- LAST YEAR NEEDED
  connect by level <= 3;
*/

,sexlookup
as
(
select 1 as basesex, '1' as sex from dual 
union
select 2 as basesex, '2' as sex from dual 
union
select 1 as basesex, 'All' as sex from dual 
union
select 2 as basesex, 'All' as sex from dual
)

-- year look up
-- This is hacky, there must be a better way? 
-- But it does produce a look up table for 2013-2017
-- and also the three year rolling groups for 2013-2017

,yearlookup
as
(
select n as baseyear
, to_char(n) as year
from
 ( select rownum n  from dual 
 -- LAST YEAR NEEDED
  connect by level <= 2017
 )
 -- FIRST YEAR NEEDED
where n >= 2013
UNION
select n as baseyear
, '2013-2015' as year
from
 ( select rownum n  from dual 
 -- LAST YEAR NEEDED
  connect by level <= 2015
 )
 -- FIRST YEAR NEEDED
where n >= 2013
UNION
select n as baseyear
, '2014-2016' as year
from
 ( select rownum n  from dual 
 -- LAST YEAR NEEDED
  connect by level <= 2016
 )
 -- FIRST YEAR NEEDED
where n >= 2014
UNION
select n as baseyear
, '2015-2017' as year
from
 ( select rownum n  from dual 
 -- LAST YEAR NEEDED
  connect by level <= 2017
 )
 -- FIRST YEAR NEEDED
where n >= 2015
)

-- Making age lookup.

--select * from analysischarlieturner.ages;

-- We don't have a systematic 'we definitely used this age partition'
-- So we should assume any age partition in the age table could be being used.
-- There are currently 30 age partitions.  
-- This is a bit tedious.  

-- You can at least get a list of them:
/*
select COLUMN_NAME from ALL_TAB_COLUMNS
where owner = 'ANALYSISCHARLIETURNER'
and TABLE_NAME = 'AGES'
order by COLUMN_NAME;
*/
-- If I had grip, I would write some R to automate creating this table
-- Instead I did it in Excel
, agelookup
as
(
select distinct floor(AGES.AGE/5)+1 as baseage, 'All' as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_30_50_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_40 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_50_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_50_70_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_20_TO_40 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_25_50 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_50_70_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_TO_50 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_30_TO_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_35 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_40 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_40_TO_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_70_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_TO_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_50_TO_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_5_10_20_30_50_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_70_75_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_60_TO_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70_75_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_70_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, SPLIT_80 as age from analysischarlieturner.ages
UNION
select distinct floor(AGES.AGE/5)+1 as baseage, TENYEARAGE as age from analysischarlieturner.ages)

-- So, I have a region lookup, a sex lookup, a year lookup, and an age lookup.

-- And some populations!  Yay.  Now just join them all together.

-- We have no joins for the Welsh LSOAs and for the years before 2013. 
-- But that is what we wanted
-- All ages and sexs have joined to something.  


, population_table as
(
select g.region, s.sex, y.year, a.age, sum(popcount) as popcount from ons2017.populations_normalised POPS
left outer join geoglookup g 
on pops.lsoa11 = g.lsoa11
left outer join sexlookup s
on pops.sex = s.basesex
left outer join yearlookup y
on pops.year = y.baseyear 
left outer join agelookup a
on pops.quinaryagegroupint = a.baseage
group by g.region, s.sex, y.year, a.age
)


select 'Brain, meningeal and other primary CNS tumours' as "Cancer Site" 
,"Year" as "Year"	
,"Tumour Type" as "Tumour Type"	
,'Not applicable' as "Stage"	
, case when "Age" = 'All' then 'All ages' else "Age" end as "Age"
-- Region doesn't work, you need "Region" now.  Odd odd odd
, case when "Region" = 'All' then 'All England' else "Region" end as "Region"
, case when "Sex" = 'All' then 'Persons' else "Sex" end as "Sex"
, 'Not split by grade' as "Grade" 
, 'Not applicable' as "Nodal Status"
, Incidence as "Incidence"
, pops.popcount  as "Population"
from extractpartitions ep
left outer join population_table pops
on ep."Year" = pops.year
-- This is a hack because North Of is not North of
and substr(ep."Region",1,4) = substr(pops.region,1,4)
and (case when ep."Sex" = 'Male' then '1' when ep."Sex" = 'Female' then '2' else 'All' end) = pops.sex
and ep."Age" = pops.age
;