sql 新增用户、用户访问量以及点击数

sql 新增用户、用户访问量以及点击数

具体sql语句如下：

 

--新增用户
SELECT DATEPART(day,adddate),COUNT(*) FROM [users]..users
WHERE adddate>'2010-10-08' AND adddate<'2010-10-14'
GROUP BY DATEPART(day,adddate)
ORDER BY DATEPART(day,adddate)
;

--用户访问量和点击量
SELECT DATEPART(day,LastLoginTime),
(SELECT COUNT(DISTINCT UserID) FROM [users]..UserLoginLog WHERE LoginTime>'2010-10-01'
AND LoginTime<'2010-10-08'
AND DATEPART(day,LastLoginTime)=DATEPART(day,LoginTime))
,
(SELECT COUNT(*) FROM [users]..UserLoginLog WHERE LoginTime>'2010-10-01'
AND LoginTime<'2010-10-08'
AND DATEPART(day,LastLoginTime)=DATEPART(day,LoginTime))

FROM [users]..users
WHERE LastLoginTime>'2010-10-01' AND LastLoginTime<'2010-10-08'
GROUP BY DATEPART(day,LastLoginTime)
ORDER BY DATEPART(day,LastLoginTime)
;