Sysop gender gap

SQL

SELECT COUNT(*) AS 'sysops with non-default',
    SUM(up_value='female' AND up_property='gender') AS female,
    SUM(up_value='male' AND up_property='gender') AS male,
    SUM(up_value='unknown' AND up_property='gender') AS unknown,
    concat(round(SUM(up_value='female' AND up_property='gender') * 100 / count(*), 1), "%") as "female %",
    concat(round(SUM(up_value='male' AND up_property='gender') * 100 / count(*), 1), "%") as "male %",
    concat(round(SUM(up_value='unknown' AND up_property='gender') * 100 / count(*), 1), "%") as "unknown %",
FROM user_properties
    INNER JOIN user_groups ON up_user=ug_user
WHERE ug_group='sysop'
SQL

Checking query status...
