Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
select *, cast(t1."with_post"/t2."all" as float) as "res" from (select count(distinct u.Id) as "with_post" from Users u full outer join Posts p on (p.OwnerUserID = u.Id) where p.Id is null)t1 cross join (select count(u.Id) as "all" from Users u)t2 ;