Staff Counts: Difference between revisions
Jump to navigation
Jump to search
(update staff figures) |
(update for 2018) |
||
Line 1: | Line 1: | ||
[[File: | [[File:Staff_over_Time_2018.png]] | ||
<!-- | |||
select year, sum(staff) as staff, sum(volunteer) as volunteers, count(user_id) as total | |||
from ( | |||
select year, user_id, MIN(rank) < 7 as staff, MIN(rank) = 7 as volunteer | |||
from staff | |||
where active = 1 | |||
group by year, user_id | |||
) as agg | |||
group by year | |||
order by year desc | |||
--> | |||
{| class="wikitable" style="text-align: right;" | {| class="wikitable" style="text-align: right;" | ||
Line 9: | Line 21: | ||
|- | |- | ||
| 2018 | | 2018 | ||
| | | 56 | ||
| | | 38 | ||
| | | 94 | ||
|- | |- | ||
| 2017 | | 2017 | ||
| | | 74 | ||
| | | 51 | ||
| | | 125 | ||
|- | |- | ||
| 2016 | | 2016 | ||
| 72 | | 72 | ||
| | | 49 | ||
| | | 121 | ||
|- | |- | ||
| 2015 | | 2015 | ||
| 73 | | 73 | ||
| | | 68 | ||
| | | 141 | ||
|- | |- | ||
| 2014 | | 2014 | ||
Line 45: | Line 57: | ||
| 2011 | | 2011 | ||
| 77 | | 77 | ||
| | | 20 | ||
| | | 97 | ||
|- | |- | ||
| 2010 | | 2010 | ||
| 44 | | 44 | ||
| | | 52 | ||
| | | 96 | ||
|} | |} |