T297990 When creating new talk pages, what % of users' edits add a comment?

SQL

select actor_user, count(*), sum(_added_comment), sum(_added_comment)/count(*)
from (
	select actor_user, rc_id, (
		select count(*) from change_tag
		left join change_tag_def ON ctd_id = ct_tag_id
		where ct_rc_id = rc_id
		and ctd_name='discussiontools-added-comment'
	) as _added_comment
	from recentchanges
	left join actor on rc_actor=actor_id
	where rc_new = 1
	and rc_bot = 0
	and rc_source = 'mw.new'
	and rc_namespace % 2 = 1
	and actor_user is not null
	-- and rc_timestamp>'20211220' and rc_timestamp<'20211223'
) t
group by actor_user
having count(*) > 5
order by 4

SQL

Checking query status...