not including deleted questions, or community wiki questions
Q&A for participants in team and individual sport activities
-- Users with more than 400 upvotes on their questions -- not including deleted questions, or community wiki questions select p.OwnerUserId as [User Link], u.Reputation, COUNT(*) as "Question upvotes" from Votes p2v join Posts p on p2v.PostId = p.Id join Users u on p.OwnerUserId = u.Id where p.PostTypeId = 1 and p2v.VoteTypeId = 2 and p.CommunityOwnedDate is null and p.OwnerUserId is not null group by p.OwnerUserId, u.reputation having COUNT(*) > 400 order by reputation desc