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>
Last modified
11 years ago
Last modified on Jun 5, 2013, 11:10:36 PM
Note:
See TracWiki
for help on using the wiki.