select event_user_text_latest, count(*) as talk_creations
from wmf.mediawiki_history
where 
    snapshot = "2017-04" and
    wiki_db = "kowiki" and
    event_entity = "revision" and
    event_type = "create" and
    revision_parent_id = 0 and
    page_namespace = 3 and
    event_timestamp > "201611"
group by event_user_text_latest