Can you please help me in generating Monthly Report by Category/Technician

Wherein it shows Raised Request for this month and Close Request for this month without inheriting 'Closed Request that has been raised last month'

mysql Version 9.1 build 9118 ​
​ ​