11、Mastering Date - Based Data Analysis with SQL

掌握SQL日期数据分析

redis7keeper

于 2025-09-15 09:55:23 发布

阅读量14

点赞数

CC 4.0 BY-SA版权

分类专栏：掌握Spark SQL实战精髓文章标签： SQL date analysis YEAR

本文链接：https://blog.youkuaiyun.com/redis7keeper/article/details/153172194

掌握Spark SQL实战精髓专栏收录该内容

39 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

Mastering Date - Based Data Analysis with SQL

1. Aggregating Data over a Date Range

Let’s say your sales manager wants to know the average daily purchase amount over six months. You can use the following SQL code:

SELECT     SUM(Cost) 
           / DATEDIFF('2015-12-31', '2015-07-01')
             AS AverageDailyCost
FROM       allsales
WHERE DateBought BETWEEN '2015-07-01' AND '2015-12-31';

How it works

Date Range Filtering : The WHERE clause filters the data for the date range from July 1, 2015, to December 31, 2015.
Total Cost Calculation : The SUM() function in the SELECT clause calculates