Vote trends on my posts


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select year(p.CreationDate), 
       Name "Downvotes per post",
       1.0*count(distinct v.Id)/count(distinct p.Id)
from Votes v
     join Posts p on PostId = p.Id
     join VoteTypes vt on vt.Id = VoteTypeId
where OwnerUserId = ##user?1438##
      --and Name = 'DownMod'
group by year(p.CreationDate), Name

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results