hessDaily Status
Updated 2023-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select trunc(createdat,'month') as date, 'Create' as type, count(DISTINCT(title)) as total_commit, count(DISTINCT(author)) as total_developer,
count(DISTINCT(repo)) as total_repo
from near.beta.github_activity
group by 1,2
UNION
select trunc(UPDATEDAT,'month') as date, 'Update' as type, count(DISTINCT(title)) as total_commit, count(DISTINCT(author)) as total_developer,
count(DISTINCT(repo)) as total_repo
from near.beta.github_activity
group by 1,2
UNION
select trunc(CLOSEDAT,'month') as date, 'Close' as type, count(DISTINCT(title)) as total_commit, count(DISTINCT(author)) as total_developer,
count(DISTINCT(repo)) as total_repo
from near.beta.github_activity
group by 1,2
Run a query to Download Data