訂單表

select firstmon as '月份', count(userid) as '新增', sum(fugou) as '復(fù)購人數(shù)', sum(fugou)/count(userid) as '復(fù)購率' from (select t1.firstmon, t1.userid, if(count(t1.userid)>1, 1, 0) as fugoufrom (select userid, month(min(paytime)) as firstmonfrom `order`group by userid) t1left join `order` t2ont1.userid = t2.userid andt1.firstmon = month(t2.paytime)group byt1.firstmon, t1.userid ) t3 group by firstmon;

總結(jié)

以上是生活随笔為你收集整理的SQL 每月新增，复购人数，复购率的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。