3 -- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 CREATE OR REPLACE VIEW reporter.demographic AS
11 WHEN AGE(u.dob) > '18 years'::INTERVAL
14 END AS general_division,
17 THEN 'No Date of Birth Entered'::text
18 WHEN age(u.dob::timestamp with time zone) >= '0 years'::interval and age(u.dob::timestamp with time zone) < '6 years'::interval
19 THEN 'Child 0-5 Years Old'::text
20 WHEN age(u.dob::timestamp with time zone) >= '6 years'::interval and age(u.dob::timestamp with time zone) < '13 years'::interval
21 THEN 'Child 6-12 Years Old'::text
22 WHEN age(u.dob::timestamp with time zone) >= '13 years'::interval and age(u.dob::timestamp with time zone) < '18 years'::interval
23 THEN 'Teen 13-17 Years Old'::text
24 WHEN age(u.dob::timestamp with time zone) >= '18 years'::interval and age(u.dob::timestamp with time zone) < '26 years'::interval
25 THEN 'Adult 18-25 Years Old'::text
26 WHEN age(u.dob::timestamp with time zone) >= '26 years'::interval and age(u.dob::timestamp with time zone) < '50 years'::interval
27 THEN 'Adult 26-49 Years Old'::text
28 WHEN age(u.dob::timestamp with time zone) >= '50 years'::interval and age(u.dob::timestamp with time zone) < '60 years'::interval
29 THEN 'Adult 50-59 Years Old'::text
30 WHEN age(u.dob::timestamp with time zone) >= '60 years'::interval and age(u.dob::timestamp with time zone) < '70 years'::interval
31 THEN 'Adult 60-69 Years Old'::text
32 WHEN age(u.dob::timestamp with time zone) >= '70 years'::interval
33 THEN 'Adult 70+'::text