Q&A for people interested in the history and origins of science and mathematics
select count(v.postid) as 'Vote count', v.postid AS [Post Link], p.ViewCount as "Views", p.creationdate as "Date", round(2.5,count(v.postid)/cast(p.ViewCount as float)) as [Ratio] from votes v inner join posts p on p.id=v.postid where PostTypeId = 1 and v.VoteTypeId in (2,3) group by v.postid,p.ViewCount, p.creationdate order by Date desc