I'm looking voor a solution for the next question. in a table i have subscriptions with a ~start_date~ , ~end_date~ and a ~paid_till_date~. These subscriptions also have a ~person_id~.
Im looking to build a query to find the subscriptions for persons who have paid double for the same day and i would like the double subscriptions in the result of the query. Can somebody Help?
person_id '2' has 2 subscriptions
end_date 2017-07- 14
end_date 2017-07- 17
These subs overlap and '2' wil pay double for a few days.