Year-wise male_female ratio

SQL

WITH genderEdits AS (
    SELECT  
        up.up_value AS gender,
        substr(r.rev_timestamp,1,4) AS year,
        COUNT(r.rev_id) AS revision_count 
    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_user
    WHERE 
        YEAR(u.user_registration) IN (2019, 2021, 2022, 2023, 2024)
        AND up.up_property = 'gender'
    GROUP BY 
        up.up_value, substr(r.rev_timestamp,1,4)
)
SELECT
    year,
    ROUND(SUM(CASE WHEN gender = 'male' THEN revision_count ELSE 0 END) / 
          NULLIF(SUM(revision_count), 0), 2) AS male_ratio,
    ROUND(SUM(CASE WHEN gender = 'female' THEN revision_count ELSE 0 END) / 
          NULLIF(SUM(revision_count), 0), 2) AS female_ratio,
    ROUND(SUM(CASE WHEN gender = 'male' THEN revision_count ELSE 0 END) / 
          NULLIF(SUM(CASE WHEN gender = 'female' THEN revision_count ELSE 0 END), 0), 2) AS male_female_ratio
FROM 
    genderEdits
WHERE 
    year IN ('2019', '2021', '2022', '2023', '2024')
GROUP BY 
    year
ORDER BY 
    year;
SQL

Checking query status...
