🏠 Ana Sayfa
Benchmarklar
📊 Tüm Benchmarklar 🦖 Dinozor v1 🦖 Dinozor v2 ✅ To-Do List Uygulamaları 🎨 Yaratıcı Serbest Sayfalar 🎯 FSACB - Nihai Gösteri 🌍 Çeviri Benchmarkı
Modeller
🏆 En İyi 10 Model 🆓 Ücretsiz Modeller 📋 Tüm Modeller ⚙️ Kilo Code
Kaynaklar
💬 Prompt Kütüphanesi 📖 YZ Sözlüğü 🔗 Faydalı Bağlantılar
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.