Q&A for system and network administrators
SELECT (SELECT COUNT(v.id) FROM votes v where v.VoteTypeId = '2') as votesUp, (SELECT COUNT(v.id) FROM votes v where v.VoteTypeId = '3') as votesDown, COUNT(distinct p.id) as posts, CAST( CAST(COUNT(CASE when v.VoteTypeId = '2' then v.id end) as DECIMAL(20,5)) / CAST(COUNT(distinct p.id) as DECIMAL(20,5)) as DECIMAL(20,5)) as voteweightUp, CAST( CAST(COUNT(CASE when v.VoteTypeId = '3' then v.id end) as DECIMAL(20,5)) / CAST(COUNT(distinct p.id) as DECIMAL(20,5)) as DECIMAL(20,5)) as voteweightDown FROM posts p left join votes v on p.id = v.postid left join comments c on p.id = c.postid and p.creationdate > '2014-01-01'