Write a SQL query to calculate the rolling 3-month retention rate of subscribers from a transactional database.