Untitled query #86640

SQL

WITH base AS (
  SELECT YEAR(rev_timestamp) AS year,
         user_name,
         COUNT(DISTINCT rev_id) AS edits_count,
         CASE
    	    WHEN up_property = 'gender' THEN up_value
            ELSE 'unknown'
         END AS gender
  FROM
  		revision
  JOIN
  		actor
  		ON rev_actor = actor_id
  JOIN
  		user
  		ON actor_user = user_id
  JOIN 
        user_properties 
        ON user_id = up_user
  WHERE
  		actor_name IS NOT NULL
  		AND YEAR(rev_timestamp) BETWEEN 2019 AND 2024
  		AND user_name NOT LIKE '%Bot%'
        AND user_name NOT LIKE 'MediaWiki message delivery'
  GROUP BY
  		user_name
  ORDER BY
        edits_count DESC 
)

SELECT
*
FROM
base
WHERE edits_count > 5
SQL

Checking query status...
