0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT 
COUNT(p.Id) UnansweredPosts,
tg.TagName
FROM 
    Posts p
INNER JOIN 
    PostTags t on p.Id = t.PostId
INNER JOIN
    Tags tg on tg.Id = t.TagId
WHERE 
    tg.TagName IN ('react-native', 'react-native-windows', 'xamarin', 
                   'kotlin', 'kotlin-native', 'kotlin-interop', 'cordova',
                   'ionic-framework', 'flutter', 'titanium', 'javascript')
    AND p.PostTypeId = 1 -- Questions
    AND (AnswerCount IS NULL OR AnswerCount = 0)
GROUP BY tg.TagName

fork query

edited feb 28 19

created feb 21 19 anonymous