Comparison of cross-platform frameworks

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 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