Angular & React & Vue

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  cast(floor(cast(p.creationDate as float) / 30) * 30 as datetime),
  
  --sum(iif(t.TagName = N'reactjs', 1, 0)) as [react],
  --sum(iif(t.TagName in (N'angular2', N'angular4', N'angular5'), 1, 0)) as [a2+],
  --sum(iif(t.TagName = N'vue.js', 1, 0)) as [vue],
  --sum(iif(t.TagName = N'angularjs', 1, 0)) as [ang.js],
  
  round(sum(iif(t.TagName = N'reactjs', 1, 0)) * 100.0 / count(*), 1) as [react %],
  round(sum(iif(t.TagName in (N'angular', N'angular2', N'angular4', N'angular5'), 1, 0)) * 100.0 / count(*), 1) as [a2+ %],
  round(sum(iif(t.TagName = N'vue.js', 1, 0)) * 100.0 / count(*), 1) as [vue %],
  round(sum(iif(t.TagName = N'angularjs', 1, 0)) * 100.0 / count(*), 1) as [ang.js %],
  
  --count(distinct p.Id) as [questions],
  --count(*) as [total],
  round(count(distinct p.Id) * 100.0 / count(*), 1) as [accuracy %]
from
  Posts p
  inner join PostTags pt on p.Id = pt.PostId
  inner join Tags t on pt.TagID = t.Id
where
  t.TagName in (N'reactjs', N'angular', N'angular2', N'angular4', N'angular5', N'angularjs', N'vue.js')
  and p.PostTypeId = 1
group by
  cast(floor(cast(p.creationDate as float) / 30) * 30 as datetime) 
order by
  1 desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results