Downvotes on posts containing 'Maple' for a user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

declare @UserId int = ##UserId##

select
 COUNT(*) AS DownVotes
from Posts
 inner join Votes on Votes.PostId = Posts.Id and VoteTypeId = 3
where Posts.PostTypeId=2 and Posts.OwnerUserId = @UserId and 
      Posts.body like '%aple%'
Order By DownVotes Desc

Enter Parameters

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