Untitled query #86439

SQL

SELECT substr(rev_timestamp,1,4),
    SUM(CASE WHEN up.up_value = 'male' THEN 1 ELSE 0 END) AS male_edits,
    SUM(CASE WHEN up.up_value = 'female' THEN 1 ELSE 0 END) AS female_edits,
    ROUND(
        SUM(CASE WHEN up.up_value = 'male' THEN 1 ELSE 0 END) / 
        NULLIF(SUM(CASE WHEN up.up_value = 'female' THEN 1 ELSE 0 END), 0), 
    2) AS male_female_ratio
FROM 
    user u
LEFT JOIN 
    user_properties up ON u.user_id = up.up_user  
LEFT JOIN 
    revision r ON u.user_id = r.rev_id
WHERE 
    substr(rev_timestamp,1,4) IN (2020, 2021, 2022, 2023, 2024)
GROUP BY 
    substr(rev_timestamp,1,4);
SQL

Checking query status...
