Mobile development frameworks questions by month comparison

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mobile development frameworks questions by month comparison including Flutter, React Native, AngularJS, Vue.js, Xamarin, Cordova and Ionic

Physics

Q&A for active researchers, academics and students of physics

select
  mois as "Month",
  max(case when tag = 'flutter' then total end) as Flutter,
  max(case when tag = 'react-native' then total end) as "React Native",
  max(case when tag = 'angularjs' then total end) as AngularJS,
  max(case when tag = 'vue.js' then total end) as VueJS,
  max(case when tag = 'xamarin' then total end) as Xamarin,
  max(case when tag = 'cordova' then total end) as Cordova,
  max(case when tag = 'ionic-framework' then total end) as Ionic
from (
  select
    format(p.CreationDate, 'MMM yyyy') as mois,
    t.TagName as tag,
    count(p.id) as total
  from
    Posts p
    inner join PostTags pt on p.Id = pt.PostId
    inner join Tags t on t.Id = pt.TagId
  where
    p.CreationDate > '2018-01-01' AND
    (
      t.TagName = 'flutter'
      or t.TagName = 'react-native'
      or t.TagName = 'angularjs'
      or t.TagName = 'vue.js'
      or t.TagName = 'xamarin'
      or t.TagName = 'cordova'
      or t.TagName = 'ionic-framework'
    )
  group by
    format(p.CreationDate, 'MMM yyyy'),
    t.TagName
) q
group by mois
order by convert(DateTime, mois, 101)

Enter Parameters

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