🏠 首页
基准测试
📊 所有基准测试 🦖 恐龙 v1 🦖 恐龙 v2 ✅ 待办事项应用 🎨 创意自由页面 🎯 FSACB - 终极展示 🌍 翻译基准测试
模型
🏆 前 10 名模型 🆓 免费模型 📋 所有模型 ⚙️ 🛠️ 千行代码模式
资源
💬 💬 提示库 📖 📖 AI 词汇表 🔗 🔗 有用链接
Hard

Advanced SQL Window Functions

#sql #database #data-analysis

Construct a complex query using window functions to analyze time-series data.

Write a PostgreSQL query that calculates the 3-day moving average of sales for each product, alongside the difference from the previous day's sales, partitioned by store location. Handle NULL values by carrying forward the last known value using the IGNORE NULLS option within the window frame.