SELECT

author,

COUNT(CASE WHEN state = 'OPEN' OR state = 'MERGED' THEN 1 ELSE NULL END) as pull_requests

FROM near.beta.github_activity

WHERE state = 'OPEN' OR state = 'MERGED'

GROUP BY 1

SELECT author, pull_requests FROM monthly_activity