1321. Restaurant Growth | Top 50 SQL Series |

Опубликовано: 07 Июнь 2025
на канале: SheCodes

🚀 SQL Tutorial: Moving Average Calculation – LeetCode Problem 1321

Hey SQL enthusiasts! In today’s video, we’re diving deep into LeetCode Problem 1321: Restaurant Growth, where we’ll analyze customer transactions at a restaurant and compute a 7-day moving average of customer spending. 💸🍽️

📊 Problem Breakdown:
You’re the restaurant owner looking to expand your business, and you want insights into customer spending trends. How do you do that? By calculating the moving average of the total customer amount over a 7-day window (including the current day and the previous 6 days). This moving average gives you a great snapshot of spending patterns to help with decision-making!

🔍 What You’ll Learn:

How to use SQL’s window functions and date arithmetic.
Mastering the DATE_ADD and DATE_SUB functions to calculate ranges.
The use of INTERVAL for manipulating dates.
Subqueries to calculate sums and averages over specific date ranges.
Efficient SQL practices to solve real-world problems!
📝 Example Walkthrough: Imagine your customers visit the restaurant daily, and you want to calculate the average spending over the last 7 days. With SQL, we can seamlessly query this information, round the averages to two decimal places, and display the results in an ordered, easy-to-read format.

🎯 Whether you’re a beginner learning SQL or prepping for technical interviews, this tutorial will level up your understanding of moving averages and time-based calculations. 🚀

💡 Don’t forget to like, subscribe, and share for more SQL content and interview prep tutorials!

👉 Let’s code smarter, not harder!

#SQL #LeetCode #RestaurantGrowth #MovingAverage #DataAnalysis #SQLTutorial #SQLInterview #TechPrep #DataScience #TimeSeries #Programming #SheCo