SQL Interview Query |New, Repeat, Active, Lapsed Customers | 2 methods

In this video tutorial, we solve one of the most asked interview SQL queries - Identify New, Repeat, Active, Inactive customers.
Two methods to approach this scenario are discussed.
This video is sponsored by Coupler.io.
You can sign up for a free trial here -
app.coupler.io...
All the SQL statement and practice data is available at the below link -
know-star.blog...
How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.ne...
Beginners to Python Programming
skillshare.eqc...
Data Science and Business Analytics with Python
skillshare.eqc...
Get 40% OFF of Skillshare with code FLASH40 - October 2022
skillshare.eqc...
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.ne...
Python for Everybody Specialization
imp.i384100.ne...
Google Data Analytics Professional Certificate
imp.i384100.ne...
Coursera Plus - Data Science Career Skills
imp.i384100.ne...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - [e-mail]

[@riddlex]

This was super helpful. I had appeared for a DA interview in Amazon, and a similar question was asked to me.

[@LearnatKnowstar]

Thank you. Glad it was helpful 🙏

[@scotthaggard]

Thanks for a good video, but seems like one has to come in understanding how a window function works, which I didn't expect when clicking into it. I feel the mention at the end about needing to "brush up on your windows functions" would be better stated in the beginning. Otherwise, very useful information! You have earned my sub today ;)

[@LearnatKnowstar]

Thank you so much for your support.
Will keep your feedback in mind and incorporate in further videos !!

[@nikolaybaranov2213]

Excellent! Although there is nothing new about window functions, this is a good example of how to use them.

[@LearnatKnowstar]

Thank you 🙏

[@adilmajeed8439]

Thanks for sharing. Nice video

[@LearnatKnowstar]

Glad it was useful.

[@diydecor2653]

Another awesome video tutorial. I have faced this SQL query in multiple interviews.

[@LearnatKnowstar]

🙏

[@sravankumar1767]

Superb explanation 👌 👏 👍

[@LearnatKnowstar]

Glad you liked it

[@kristyowens2284]

Thank you for sharing the two approaches. I was aware of the first one but the second one is very informative.

[@LearnatKnowstar]

Glad it was helpful

[@sushmitachanda230]

Thank for this informative video... Can u help me if I have to compare transaction of each customer with reference to month and then tag them new active and lapsed but if the customer is continuing to pay every month then it should be tagged active instead of new customer for first month... Kindly help me in this regards

[@DChangeChannel]

I don't know if it's my SQL version, but I got an error that the "LAG" function is not a recognized built-in function name. Please what can you say about this and is there an alternative approach to this? thanks

[@sravankumar1767]

Can you please provide the schema it will be useful for us for practice purpose

[@rk-ej9ep]

This is useful..👍

[@LearnatKnowstar]

Thank you

[@designanddecor8964]

Great stuff. Very helpful.

[@LearnatKnowstar]

Glad it was helpful!