Find Customers with Decreasing Sales | SQL Window Function Interview Question asked in Google

🚀 In this video, we solve a popular SQL interview-style question:

"How do you find customers whose transaction amount decreased at any point during January 2024?"

We'll walk through:

Using LAG() window function to compare each transaction with the previous one

Tackle NULL Value

Filtering based on date range (Jan 2024)

Understand why we need "Distinct"

Find Solution in Comment

🎓 Great for Data Analyst, Data Engineer, or Business Intelligence interviews!
#sql #sqlinterviewquestions #analytics #analyticsinterview #businessanalytics #datainterview

👉 Subscribe to @Asli_Analytics for more real-world analytics learning!
🎯 Follow Me On Social Media:

LinkedIn: https://www.linkedin.com/in/gauravowlcity/

Instagram: https://www.instagram.com/asli_analytics/

Twitter/X: https://x.com/Gauravlytics

Видео Find Customers with Decreasing Sales | SQL Window Function Interview Question asked in Google канала Gaurav Agrawal