Year-wise male_female ratio

SQL

SELECT 
    substr(r.rev_timestamp, 1, 4) AS year,
    up.up_value AS gender,
    COUNT(r.rev_id) AS revision_count,
    ROUND(COUNT(CASE WHEN up.up_value = 'male' THEN 1 END) / 
          NULLIF(COUNT(r.rev_id), 0), 2) AS male_edits,
    ROUND(COUNT(CASE WHEN up.up_value = 'female' THEN 1 END) / 
          NULLIF(COUNT(r.rev_id), 0), 2) AS female_edits,
    ROUND(COUNT(CASE WHEN up.up_value = 'male' THEN 1 END) / 
          NULLIF(COUNT(CASE WHEN up.up_value = 'female' THEN 1 END), 0), 2) AS male_female_ratio
FROM 
    user AS u
LEFT JOIN 
    user_properties AS up ON u.user_id = up.up_user
LEFT JOIN
    revision AS r ON u.user_id = r.rev_id
WHERE 
    YEAR(u.user_registration) IN (2019, 2020, 2021, 2022, 2023, 2024)
    AND up.up_property = 'gender'
    AND r.rev_timestamp IS NOT NULL
GROUP BY 
    substr(r.rev_timestamp, 1, 4), up.up_value
ORDER BY 
    year;
SQL

Checking query status...
