Score per views (log plot, draft)


Please login or register to vote for this query.

(click on this box to dismiss)

Theoretical Computer Science

Q&A for theoretical computer scientists and researchers in related fields

select /*Q.Id as [Post Link], A.Id as AnswerId
,*/ log(Q.ViewCount), log(A.MaxScore) --, cast(A.Score as decimal)/ Q.ViewCount as Ratio
from Posts Q
inner join  (
  select ParentId, max(Score) as MaxScore
  from Posts
  group by ParentId
  ) A on A.ParentId = Q.Id
inner join PostTags PT on PT.PostId = Q.Id
inner join Tags T on T.Id = PT.TagId
where T.TagName = 'python'
  and A.MaxScore > 10
--order by Ratio desc
order by Q.ViewCount desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results