Untitled query #86458

SQL

SELECT 
    substr(rev.rev_timestamp, 1, 4) AS year, 
    COUNT(CASE WHEN up.up_value = 'male' THEN 1 END) AS male_count,
    COUNT(CASE WHEN up.up_value = 'female' THEN 1 END) AS female_count,
    COUNT(CASE WHEN up.up_value NOT IN ('male', 'female') THEN 1 END) AS other_count
FROM 
    revision rev
JOIN 
    user u ON rev.rev_user = u.user_id
JOIN 
    user_properties up ON u.user_id = up.up_user
WHERE 
    substr(rev.rev_timestamp, 1, 4) IN ('2020', '2021', '2022', '2023', '2024')
AND 
    up.up_property = 'gender'
GROUP BY 
    year
ORDER BY 
    year;
SQL

Checking query status...
