Percentage of users with rep=1 and with just a single question post, deleted or not

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(*)= 1 and max(p.PostTypeId)= 1
) as Chosen))/(1.0*(select count(*) from Users))*100

Enter Parameters

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