Untitled query #29060

SQL

SELECT
	YEAR(user_registration) AS reg_year,
    COUNT(DISTINCT user_id) AS n_users,
    COUNT(DISTINCT CASE WHEN user_editcount = 0 THEN user_name END) AS users_0edits,
    COUNT(DISTINCT CASE WHEN user_editcount BETWEEN 1 AND 100 THEN user_name END) AS users_1_100edits,
    COUNT(DISTINCT CASE WHEN user_editcount BETWEEN 101 AND 500 THEN user_name END) AS user_101_500edits,
    COUNT(DISTINCT CASE WHEN user_editcount > 500 THEN user_name END) users_above_500_edits
FROM
	user
LEFT JOIN
	user_groups ug
    ON user.user_id = ug.ug_user
WHERE
	user_name = "Pranayraj1985"
    AND
	user_registration BETWEEN '20100101000000' AND '20231231235959'
    AND (
      ug_group IS NULL
      OR ug_group != 'bot'
    )
GROUP BY
	reg_year
ORDER BY
	reg_year
SQL

Checking query status...
