Vote trends on my posts

0

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,
       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 = 1438
      and Name = 'DownMod'
group by year(p.CreationDate), Name

Enter Parameters

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