0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select posts.id as [Post link], posts.score, posts.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)

fork query

edited apr 13 20 Martijn Pieters

created apr 13 20 anonymous