0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

with s as (select TagName,PostId
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate > '2018-01-01' and 
(TagName = 'nlp' 
or TagName = 'artificial-intelligence'
or TagName = 'classification'
or TagName = 'machine-learning'
or TagName = 'tensorflow'
or TagName = 'keras'
or TagName = 'unsupervised-learning'
or TagName = 'supervised-learning'
or TagName = 'reinforcement-learn'
or TagName = 'scikit-learning'
or TagName = 'time-series'
or TagName = 'neural-network'
or TagName = 'deep-learning'
or TagName = 'cross-validation'
or TagName = 'pytorch')),
t as (
select * from s,Posts where s.PostId = Posts.Id)

SELECT TOP 100
  u.Id AS [User Link],
  count(*) AS NumAnswers,
  sum(case when t.AcceptedAnswerId is Not NULL then 1 else 0 end) AS NumAccepted
FROM t INNER JOIN Users u ON u.Id = t.OwnerUserId
GROUP BY u.Id
ORDER BY count(*) DESC

fork query

edited oct 3 22

created oct 3 22 anonymous