= Membership Tracking = This page is a quick look at our membership numbers over time: == Active Members by Date == Members that are still active sorted by the year the membership was activated. {{{ mysql> select count(*) AS '# of members', YEAR(member_start_date) AS 'Start Year' from red_member where member_status = "active" group by YEAR(member_start_date); +--------------+------------+ | # of members | Start Year | +--------------+------------+ | 32 | 2005 | | 73 | 2006 | | 59 | 2007 | | 55 | 2008 | | 93 | 2009 | | 78 | 2010 | | 167 | 2011 | | 195 | 2012 | | 40 | 2013 | +--------------+------------+ 9 rows in set (0.00 sec) mysql> }}} == Total Memberships Created By Year == {{{ mysql> select count(*) AS '# of members', YEAR(member_start_date) AS 'Start Year' from red_member group by YEAR(member_start_date); +--------------+------------+ | # of members | Start Year | +--------------+------------+ | 79 | 2005 | | 169 | 2006 | | 103 | 2007 | | 80 | 2008 | | 138 | 2009 | | 113 | 2010 | | 194 | 2011 | | 207 | 2012 | | 42 | 2013 | +--------------+------------+ 9 rows in set (0.00 sec) mysql> }}}