Year-wise male_female ratio

SQL

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

Checking query status...
