This is an awesome query explanation, thank you! However, I’m not sure if it’s what we are looking for unfortunately.
For example, if I set parameters 01 and 2024 I am looking at January this year.
I understand that the output will include all the users who signed up in January who are still active today. Is that correct?
But what we want is the number of people who had u.active=TRUE each month since launch (not right now). Then we can plot and show how our user base has changed from month to month. At the end of every month, for us this would be:
Active users = Previous month’s value + new signups - new deletions - new deactivations
I don’t see anything about deactivations or dates being tied to the active variable in the Data Explorer. The most likely course then, may be to use the staff action logs and analyse by date BUT I don’t think that the export function is working for us. When we export staff action log results we strangely get a spreadsheet with the content of different posts, not a table of staff actions. If you guys could help us with this, maybe that would be an alternative solution! 
Are you aware of others having the same issue?