Hello, trying to get consecutive months for orders by user. So, with data that looks like this:
user order dates
Only user 1 will be returned in the query results. Users only need to have one, three-month consecutive run. So, User 2 has no consecutive runs, whereas user 1 has two consecutive runs, but one is sufficient so that all I need returned in the query results is that user.
I do not want to do this recursively, there is too much data. I did check for solutions online, but they all had variations/other criteria and since I am by no means an advanced user, I could not tease out what was applicable and what wasn't. In fact just looking at their solutions from an overview, I found the concept/methodology of the solution a bit difficult.
Any help and explanation of what's going on is appreciated!