Comparison of cross-platform frameworks

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

select CASE 
         WHEN t.TagName LIKE '%flutter%' THEN 'Flutter' 
         WHEN t.TagName LIKE '%react-native%' THEN 'React Native'
         WHEN t.TagName LIKE '%xamarin%' THEN 'Xamarin'
         WHEN (t.TagName LIKE '%cordova%' OR t.TagName LIKE '%phonegap%') THEN 'Cordova'
       END, count(DISTINCT q.Id) AS Question
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where PostTypeId=1 AND (t.TagName like '%flutter%' OR t.TagName like '%react-native%' OR t.TagName like '%xamarin%' or t.TagName like '%cordova%' or t.TagName like '%phonegap%')
-- post type 2 means that post is an answer
AND 
q.CreationDate > '2019-03-20 00:00:00'
AND
q.CreationDate < '2019-06-20 00:00:00' 
group by CASE
  WHEN t.TagName LIKE '%flutter%' THEN 'Flutter' 
  WHEN t.TagName LIKE '%react-native%' THEN 'React Native'
  WHEN t.TagName LIKE '%xamarin%' THEN 'Xamarin'
  WHEN (t.TagName LIKE '%cordova%' OR t.TagName LIKE '%phonegap%') THEN 'Cordova'
END
order by Question DESC

Enter Parameters

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