Q&A for people interested in the history and origins of science and mathematics
select top 20 count(v.postid) as 'Vote count', v.postid AS [Post Link], p.ViewCount as "Views", p.creationdate as "Date", count(v.postid)/p.ViewCount 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 p.creationdate desc