按类型计算一系列日期的成员资格

I'm using SQL Server 2012 and have a database containing membership information. I'm trying to write SQL that will count the members of each type that exist during each month so I can report on if membership is going up/down month by month. A simplified version of my schema is:I'm using SQL Server 2012 and have a database c