SELECT gen_info_reporting_period, gen_info_data_type, indicator,
split_part (qed.nuis_region_district_label,',', 2) as district,
split_part (qed.nuis_region_district_label,',', 1) as region,
fp.nuis_facility_id_label as facility_label,
(SELECT percentile_disc(0.5) WITHIN GROUP (ORDER BY indicator) FROM (SELECT indicator FROM qed WHERE gen_info_data_type = '1') as poo) as baseline_median,
(SELECT percentile_disc(0.5) WITHIN GROUP (ORDER BY indicator) FROM (SELECT indicator FROM qed) as foo) as overall_median,
ROW_NUMBER() OVER (PARTITION BY fp.nuis_facility_id_label, gen_info_data_type ORDER BY gen_info_reporting_period) as row_num
FROM qed
JOIN facility_profile fp ON qed.nuis_facility_id = fp.nuis_facility_id
GROUP BY gen_info_reporting_period, gen_info_data_type, qed.nuis_region_district_label, district, region, facility_label