What makes a bad user?
Are they users that ask six times the number of questions than answers:
User Reputation Questions Answers Upvotes Downvotes
***** 8317 465 24 776 18 ***** 5767 311 29 528 34 ***** 4844 226 14 465 135 ***** 4546 310 1 439 62 ***** 4359 371 32 452 68 ***** 4350 416 21 395 71 ***** 4193 555 74 487 112 ***** 3230 94 12 201 33 ***** 3187 92 11 331 8 ***** 2084 79 6 184 14 ***** 1973 263 1 175 8 ***** 1944 174 12 170 7 ***** 1929 160 24 216 31 ***** 1901 53 3 163 10 ***** 1771 145 16 182 23 ***** 1742 56 8 180 10 ***** 1550 50 5 138 6 ***** 1534 56 2 127 2 ***** 1514 143 0 256 7 ***** 1513 83 5 141 36
Or perhaps users that are downvoted 50% or more times than they are upvoted?
User Reputation Questions Answers Upvotes Downvotes
***** 1606 6 187 173 110 ***** 1500 214 1 152 78 ***** 1342 4 53 135 76 ***** 1056 124 0 119 75 ***** 918 64 0 109 113 ***** 911 181 1 99 62 ***** 842 43 24 80 53 ***** 746 44 34 53 55 ***** 695 116 7 75 56 ***** 670 12 96 124 142 ***** 644 50 3 35 19 ***** 638 36 0 74 75 ***** 606 21 12 52 36 ***** 585 116 7 40 22 ***** 550 2 46 65 35 ***** 520 0 71 51 29 ***** 516 8 29 30 24 ***** 479 23 29 46 34 ***** 439 30 0 59 46 ***** 422 1 31 31 16
What kind of behaviors do we not want to reward with high rep?
FYI: I wrote spShog9 to celebrate shog9s awesome formatting and wanted to showcase it a bit. I also wrote this view to make the queries a bit easier.
SQL:
select top 20 *
into #t
from UserTotals
where Questions > Answers * 6
order by Reputation desc
exec spShog9
drop table #t
go
select top 20 *
into #t
from UserTotals
where Downvotes > Upvotes * 0.5
order by Reputation desc
exec spShog9
drop table #t
