[Koha] New patrons SQL Report

Hello team, I need a report that counts and sums new patrons registered within a certain date range by gender for each category. How can I enhance this report? I dont mind a different on delivering results. SELECT categorycode, COUNT(borrowernumber) AS 'new patrons' FROM (SELECT borrowernumber, categorycode, dateenrolled FROM borrowers UNION ALL SELECT borrowernumber, categorycode, dateenrolled FROM deletedborrowers) AS patrons WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY categorycode It is not giving me the count by gender. I also want a drop down arrow allowing me to select the category that I want. Warm Regards James