Portion of confirmed users in cswiki's recent changes

SQL

USE cswiki_p;
SELECT SUM(IF(ug_user IS NULL, 1, 0)), SUM(IF(user_id IS NULL, 1, 0)), COUNT(*), SUM(IF(ug_user IS NULL, 1, 0)) / COUNT(*)
FROM recentchanges
LEFT JOIN (SELECT * FROM user WHERE user_editcount > 9 AND user_registration < 20180418163000) AS u
ON rc_user = user_id
LEFT JOIN (SELECT DISTINCT ug_user FROM user_groups WHERE ug_group IN ('autopatrolled', 'bot', 'sysop')) AS users
ON rc_user = ug_user
WHERE rc_source IN ('mw.edit', 'mw.new');

SELECT COUNT(*) FROM recentchanges
JOIN user ON rc_user = user_id
WHERE user_editcount > 9 AND user_registration < 20180418163000
AND rc_source IN ('mw.edit', 'mw.new');

SQL

Checking query status...