Deleted questions Negative voted Closed Enter missing values manual
Q&A for those who study, teach, research and apply economics and econometrics
/* (total questions - negative questions - closed - deleted) / total questions >= 0.5 */ -- negdel:# negative deleted posts "deleted recent posts link is in your profile " -- closedel:# closed deleted posts -- deleted:# deleted posts -- userid:Your userid declare @negdeleted as integer = ##negdel:int?0## declare @closeddeleted as integer = ##closedel:int?0## select (([total] + [deleted]) - ([negative] + @negdeleted) - ([closed] + @closeddeleted ) - [deleted]) / ([total] + [deleted]) [Q-ban when < 0.5] from ( select cast(count(*) as decimal) as [total] , sum(case when score < 0 then 1 else 0 end) [negative] , sum(case when closeddate is not null then 1 else 0 end) [closed] , ##deleted:int?0## [deleted] from posts where posttypeid = 1 and owneruserid = ##userid:int?5022624## ) as rawdata