本篇文章主要介绍了" 用户频次分布、新增用户留存、活跃用户留存"，主要涉及到方面的内容，对于其他数据库感兴趣的同学可以参考一下：
select * from a WHERE a.field1 NOT IN (select field1 from b)select * from a WHER...
and userid in (select userid from t_user where dt< '2016-10-01' )
)
and dt between 2017-06-01 and 2017-06-30
group by cityid
--单均价、人均单、车均单
select cityid,sum(balance)/count(orderid) as 单均价,count(orderid)/count(distinct userid) as 人均单，count(orderid)/count(distinct carid) as 车均单，
from t_order inner join t_price on t_order.orderid=t_price.orderid
group by cityid
以上就介绍了 用户频次分布、新增用户留存、活跃用户留存，包括了方面的内容，希望对其他数据库有兴趣的朋友有所帮助。
本文网址链接：http://www.codes51.com/article/detail_4436524_2.html
