select posts.id as [Post link], posts.score, coalesce(pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select posts.id as [Post link], posts.score, coalesce(posts.ViewCount, question.ViewCount),
cast(coalesce(posts.ViewCount, question.ViewCount) as float) / posts.Score as ratio
from Posts
left outer join Posts question on Posts.ParentId = question.id
where posts.id in (55910468, 55729879)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results