1SELECT
2  '2005' AS fiscal_year,
3  ROUND(AVG(median2005)) AS national_avg_median
4FROM
5  "@hud.income_limits_fy2005.section8"
6UNION ALL
7SELECT
8  '2006',
9  ROUND(AVG(median2006))
10FROM
11  "@hud.income_limits_fy2006.section8"
12UNION ALL
13SELECT
14  '2007',
15  ROUND(AVG(median2007))
16FROM
17  "@hud.income_limits_fy2007.section8_rev"
18UNION ALL
19SELECT
20  '2008',
21  ROUND(AVG(median2008))
22FROM
23  "@hud.income_limits_fy2008.section8"
24UNION ALL
25SELECT
26  '2009',
27  ROUND(AVG(median2009))
28FROM
29  "@hud.income_limits_fy2009.section8"
30UNION ALL
31SELECT
32  '2010',
33  ROUND(AVG(median2010))
34FROM
35  "@hud.income_limits_fy2010.section8"
36UNION ALL
37SELECT
38  '2011',
39  ROUND(AVG(median2011))
40FROM
41  "@hud.income_limits_fy2011.section8"
42UNION ALL
43SELECT
44  '2012',
45  ROUND(AVG(median2012))
46FROM
47  "@hud.income_limits_fy2012.section8"
48UNION ALL
49SELECT
50  '2013',
51  ROUND(AVG(median2013))
52FROM
53  "@hud.income_limits_fy2013.section8"
54UNION ALL
55SELECT
56  '2014',
57  ROUND(AVG(median2014))
58FROM
59  "@hud.income_limits_fy2014.poverty"
60UNION ALL
61SELECT
62  '2015',
63  ROUND(AVG(median2015))
64FROM
65  "@hud.income_limits_fy2015.section8_rev"
66UNION ALL
67SELECT
68  '2016',
69  ROUND(AVG(median2016))
70FROM
71  "@hud.income_limits_fy2016.section8"
72UNION ALL
73SELECT
74  '2017',
75  ROUND(AVG(median2017))
76FROM
77  "@hud.income_limits_fy2017.section8"
78UNION ALL
79SELECT
80  '2018',
81  ROUND(AVG(median2018))
82FROM
83  "@hud.income_limits_fy2018.section8"
84UNION ALL
85SELECT
86  '2019',
87  ROUND(AVG(median2019))
88FROM
89  "@hud.income_limits_fy2019.section8"
90UNION ALL
91SELECT
92  '2020',
93  ROUND(AVG(median2020))
94FROM
95  "@hud.income_limits_fy2020.section8"
96UNION ALL
97SELECT
98  '2021',
99  ROUND(AVG(median2021))
100FROM
101  "@hud.income_limits_fy2021.section8"
102UNION ALL
103SELECT
104  '2022',
105  ROUND(AVG(median2022))
106FROM
107  "@hud.income_limits_fy2022.section8"
108UNION ALL
109SELECT
110  '2023',
111  ROUND(AVG(median2023))
112FROM
113  "@hud.income_limits_fy2023.section8"
114UNION ALL
115SELECT
116  '2024',
117  ROUND(AVG(median2024))
118FROM
119  "@hud.income_limits_fy2024.section8"
120UNION ALL
121SELECT
122  '2025',
123  ROUND(AVG(median2025))
124FROM
125  "@hud.income_limits_fy2025.section8"
126ORDER BY
127  fiscal_year ASC