users with rep=1 and with <=2 post, both questions, w deleted, as a percentage of active users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select (1.0*(
select count(*) from (
select u.Id 
from (select Id from Users where Reputation = 1) as u 
join PostsWithDeleted as p
on u.Id = p.OwnerUserId
group by u.Id
having count(*) <= 2 and max(p.PostTypeId)= 1
) as Chosen))/(1.0*(
select count(*) from (
select u.Id from Users as u
join PostsWithDeleted as p
on u.Id = p.OwnerUserId
group by u.Id
) as Active
))*100

Enter Parameters

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