邀请记录表inviter(如图1),保存了被邀请人、邀请人、邀请时间的数据,需要统计出邀请人在每个月的邀请人数(图2)
图1:
图2:
mysql代码如下:
select substr(date_format(create_time,'%Y%m%d'),1,6) as create_time
,invite_member_id
,count(account_id) as inviter_num from inviter
group by substr(date_format(create_time,'%Y%m%d'),1,6)
,invite_member_id ;