count the number of angular vs react on weekly basis
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