(使用MYSQL)我需要找出特定月份每天有多少人订阅。到目前为止,我的问题是:
SELECT COUNT(user_ID) AS Subs, DATE(subscription_date) AS Day_Joined FROM Users GROUP BY DAY(Day_Joined), user_ID HAVING MONTH(Day_Joined) = 03 ORDER BY Day_Joined我想要输出给我:
subs Day_Joined
- 10 2018-03-04
- 20 2018-03-05
- 30 2018-03-06到目前为止,它给了我:
subs Day_Joined
- 5 2018-03-04
- 3 2018-03-04
- 2 2018-03-04
... and so on..发布于 2018-09-04 02:07:29
您应该仅针对Day_Joined进行分组依据
SELECT COUNT(user_ID) AS Subs
, DATE(subscription_date) AS Day_Joined
FROM Users
GROUP BY DATE(subscription_date)
HAVING MONTH(DATE(subscription_date)) = 03
ORDER BY 如果group by for user_id也没有distinct user_id的计数。
https://stackoverflow.com/questions/52154465
复制相似问题