Untitled query #86433

SQL

WITH genderEdits AS (
    SELECT  
        up_value AS gender,
        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_id
    WHERE 
        YEAR(u.user_registration) BETWEEN 2019 AND 2021
    GROUP BY 
        up_value
)
SELECT
    SUM(CASE WHEN YEAR(user_registration) = 2019 THEN revision_count ELSE 0 END) AS year_2019,
    SUM(CASE WHEN YEAR(user_registration) = 2020 THEN revision_count ELSE 0 END) AS year_2020,
    SUM(CASE WHEN YEAR(user_registration) = 2021 THEN revision_count ELSE 0 END) AS year_2021
FROM 
    genderEdits;
SQL

Checking query status...
