1SELECT
2  date_label,
3  MAX(
4    CASE
5      WHEN population_name = 'Asian' THEN value
6    END
7  ) AS asian,
8  MAX(
9    CASE
10      WHEN population_name = 'Hispanic' THEN value
11    END
12  ) AS hispanic,
13  MAX(
14    CASE
15      WHEN population_name = 'White' THEN value
16    END
17  ) AS white,
18  MAX(
19    CASE
20      WHEN population_name = 'Black' THEN value
21    END
22  ) AS black,
23  MAX(
24    CASE
25      WHEN population_name = 'American Indian/Alaska Native' THEN value
26    END
27  ) AS american_indian_alaska_native
28FROM
29  "@americashealthrankings.health_measures.measure_data"
30WHERE
31  state = 'ALL'
32  AND measure_name IN (
33    'Premature Death - American Indian/Alaska Native',
34    'Premature Death - Asian',
35    'Premature Death - Black',
36    'Premature Death - Hispanic',
37    'Premature Death - White'
38  )
39  AND population_name IN (
40    'Asian',
41    'Hispanic',
42    'White',
43    'Black',
44    'American Indian/Alaska Native'
45  )
46  AND value IS NOT NULL
47GROUP BY
48  date_label
49ORDER BY
50  date_label ASC