date_trunc('month', updatedat) as date,

case when url ilike '%pull%' then 'Pull Request' else 'Issue' end as action_type,

count(*) as no_of_actions

from near.beta.github_activity

group by 1,2

order by 1,2