Changes between Initial Version and Version 1 of membership-tracking


Ignore:
Timestamp:
Jun 5, 2013, 7:10:36 PM (8 years ago)
Author:
Ross
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • membership-tracking

    v1 v1  
     1= Membership Tracking =
     2
     3This page is a quick look at our membership numbers over time:
     4
     5== Active Members by Date ==
     6Members that are still active sorted by the year the membership was activated.
     7{{{
     8mysql> 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);
     9+--------------+------------+
     10| # of members | Start Year |
     11+--------------+------------+
     12|           32 |       2005 |
     13|           73 |       2006 |
     14|           59 |       2007 |
     15|           55 |       2008 |
     16|           93 |       2009 |
     17|           78 |       2010 |
     18|          167 |       2011 |
     19|          195 |       2012 |
     20|           40 |       2013 |
     21+--------------+------------+
     229 rows in set (0.00 sec)
     23
     24mysql>
     25}}}
     26
     27== Total Memberships Created By Year ==
     28
     29{{{
     30mysql> select count(*) AS '# of members', YEAR(member_start_date) AS 'Start Year' from red_member group by YEAR(member_start_date);
     31+--------------+------------+
     32| # of members | Start Year |
     33+--------------+------------+
     34|           79 |       2005 |
     35|          169 |       2006 |
     36|          103 |       2007 |
     37|           80 |       2008 |
     38|          138 |       2009 |
     39|          113 |       2010 |
     40|          194 |       2011 |
     41|          207 |       2012 |
     42|           42 |       2013 |
     43+--------------+------------+
     449 rows in set (0.00 sec)
     45
     46mysql>
     47}}}