Скачать или смотреть Analyzing Consecutive Events With SQL Server

Whether you are comparing the average amount of time between visits per customer or trying to figure out how many patients are readmitted every 30 days. The problem is the same in a traditional DB.

How do you compare to events for the same customer or patient. Since data is in a row format you can't easily do this.

However, you can use an analytic function to create a row number and self join your tables together to create this effect.

In this video we will be discussing why you might want to compare consecutive events and how you would go about doing it.

If you prefer reading, then you can read the basic how to here (Just skip to the part about joining consecutive events)

https://towardsdatascience.com/proble...