I have to admit, this query is quite impressive but also quite overwhelming 
Could you offer some guidance how would one go about adding one more column, mainly the ratio of topics marked as solved (with customizable period, by default within 30 days from being created) to all topics created in that month?
I have hard time modifying the query 