Staff Counts: Difference between revisions

From SNAFU Con Wiki
Jump to navigation Jump to search
(update staff figures)
(update for 2018)
 
Line 1: Line 1:
[[File:Staff_over_Time_2016.png]]
[[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
  | 66
  | 56
  | 40
  | 38
  | 106
  | 94
  |-
  |-
  | 2017
  | 2017
  | 80
  | 74
  | 52
  | 51
  | 132
  | 125
  |-
  |-
  | 2016
  | 2016
  | 72
  | 72
  | 50
  | 49
  | 122
  | 121
  |-
  |-
  | 2015
  | 2015
  | 73
  | 73
  | 71
  | 68
  | 144
  | 141
  |-
  |-
  | 2014
  | 2014
Line 45: Line 57:
  | 2011
  | 2011
  | 77
  | 77
  | 22
  | 20
  | 99
  | 97
  |-
  |-
  | 2010
  | 2010
  | 44
  | 44
  | 54
  | 52
  | 98
  | 96
  |}
  |}

Latest revision as of 06:59, 8 June 2019

Staff over Time 2018.png


Year Staff Volunteers Total
2018 56 38 94
2017 74 51 125
2016 72 49 121
2015 73 68 141
2014 77 60 137
2013 68 75 143
2012 70 47 117
2011 77 20 97
2010 44 52 96