I have a request to get an average of number of days. The tricky part is that if there is two events within 90 days, it is counted as one. Hopefully the example below will help explain it.
ID | Start Date | End Date | Num Days
01 | 01/01/2015 | 01/05/2015 | 4
02 | 02/01/2015 | 02/06/2015 | 5
03 | 08/01/2015 | 08/02/2015 | 1
ID 02 End date is less than 90 days from ID 01; therefore, it is counted as 1. While ID 03 is way past 90 days so it count as one. So, that means the average is 10/2 = 5.
How can I do this in SQL? I have no clue how to factor in 90 days check.