1WITH
2  unrate AS (
3    SELECT
4      EXTRACT (
5        YEAR
6        FROM
7          date
8      ) AS year,
9      AVG(value) AS unemployment_rate
10    FROM
11      "@fred.population_employment.observations"
12    WHERE
13      series_id = 'UNRATE'
14      AND value IS NOT NULL
15    GROUP BY
16      EXTRACT (
17        YEAR
18        FROM
19          date
20      )
21  ),
22  gdp_growth AS (
23    SELECT
24      EXTRACT (
25        YEAR
26        FROM
27          date
28      ) AS year,
29      AVG(value) AS gdp_growth_rate
30    FROM
31      "@fred.national_accounts.observations"
32    WHERE
33      series_id = 'A191RL1Q225SBEA'
34      AND value IS NOT NULL
35    GROUP BY
36      EXTRACT (
37        YEAR
38        FROM
39          date
40      )
41  )
42SELECT
43  u.year,
44  ROUND(u.unemployment_rate, 2) AS unemployment_rate,
45  ROUND(g.gdp_growth_rate, 2) AS gdp_growth_rate
46FROM
47  unrate u
48  JOIN gdp_growth g ON u.year = g.year
49ORDER BY
50  u.year