Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
select round(year(p.CreationDate), 0) year,
1.0*count(distinct v.Id)/count(distinct p.Id) "votes per post"
from Votes v
join Posts p on PostId = p.Id
join VoteTypes vt on vt.Id = VoteTypeId
where OwnerUserId = ##user?1438##
and Name like '%Mod'
and Name = 'DownMod'
group by year(p.CreationDate), Name
order by year(p.CreationDate), Name