select sum(case when 1.0*upvotes/nullif(downvotes,0) >= ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Enter Query Title
-- Enter Query Description

select sum(case when 1.0*upvotes/nullif(downvotes,0) >= y then 1 end),
sum(case when 1.0*upvotes/nullif(downvotes,0) < y then 1 end)
from users
cross join (select y=1.0*upvotes/downvotes from users where id=285587) x

Enter Parameters

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