Gender counts per reason

counts.sql

/* The MariaDB I installed doesn't support CTEs, so use a subquery */
SELECT * FROM (
    select
        reason,
        SUM( CASE WHEN gender = 'Male' THEN 1 END) as M,
        SUM( CASE WHEN gender = 'Female' THEN 1 END) as F,
        SUM( CASE WHEN gender NOT IN ('Male','Female') THEN 1 END) AS X,
        COUNT(gender) AS T
    from response
        inner join reasons on reasons.responseid = response.responseid
    group by reason
) stats
order by T desc