angular vs react posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

count the number of angular vs react on weekly basis

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

select dateadd(week, datediff(week, 0,creationdate), 0) wk, count(*) as cnt
into #angular
from posts
where tags like '%angular%'
group by dateadd(week, datediff(week, 0,creationdate), 0)
order by dateadd(week, datediff(week, 0,creationdate), 0)

select dateadd(week, datediff(week, 0,creationdate), 0) wk, count(*) as cnt
into #react
from posts
where tags like '%react%'
group by dateadd(week, datediff(week, 0,creationdate), 0)
order by dateadd(week, datediff(week, 0,creationdate), 0)

select a.wk, a.cnt angular, r.cnt react
from #angular a
join #react r on r.wk = a.wk
order by a.wk

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results