Score per views (log plot, draft)

0

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(Q.ViewCount)-7 as Ident, 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 1=1
  and A.MaxScore > 10
  and T.TagName = 'python'
--order by Ratio desc
order by Q.ViewCount desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results