实验一（mysql命令）

最新推荐文章于 2024-02-10 20:09:43 发布

Yuyy114

最新推荐文章于 2024-02-10 20:09:43 发布

阅读量291

点赞数

分类专栏：数据导入与预处理

本文链接：https://blog.csdn.net/qq_42090875/article/details/84258508

版权

数据导入与预处理专栏收录该内容

2 篇文章 0 订阅

订阅专栏

数据统计每一天发邮件的数量

select
	date_format(date,'%Y-%m-%d') as day,count(1) as counts
from
	message
where
	date_format(date,'%Y-%m-%d') between 1979-00-00 and 2008-00-00
group by
	date_format(date,'%Y-%m-%d');

统计每一周发邮件的数量

SELECT
	COUNT(1) AS counts,
	week(date) as week
FROM
	message
where
	date_format(date,'%Y-%m-%d') between 1979-00-00 and 2008-00-00
GROUP BY 
    week(date)