3 ms·

Made a 'Most Controversial' query: http://data.stackexchange.com/stackoverflow/query/281279/most-controversial-questions http://data.stackexchange.com/stackover

• nickcano 12y ago
  I liked this idea, but noticed the gap between up/down votes was actually quite large, meaning the questions weren't actually that controversial. I went ahead and made a change that filtered out results where ABS(up - down) is less than half of MAX(up, down). (its quite a bit messier than that, though, as there's no MAX function in sql that selects the greater of two operands). http://data.stackexchange.com/stackoverflow/query/282007/most-controversial-questions http://data.stackexchange.com/stackoverflow/query/282007/mos...