Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
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 like '%Mod'
--and Name = 'DownMod'
group by year(p.CreationDate), Name