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

Q&A about the site for linguists, teachers and students of the Ukrainian language

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)

fork query

edited may 15

created may 15 Yann