gistfile1.txt

select
    LOWER(ep2.value) as value,
    count( * ) as counts
from
    tracks.prod_events as events,
    events.eventprops as ep,
    events.eventprops as ep2
where
    dateymd between 20190110 and 20190212 and
    eventname = 'wpcom_hook_wpmu_new_blog' and
    ep.key = 'site_type' and
    ep.value = 'blog' and
    ep2.key = 'site_topic'
group by value
order by counts desc