How not to sort by average rating

SELECT widget_id, ((positive + 1.9208) / (positive + negative) - 
                   1.96 * SQRT((positive * negative) / (positive + negative) + 0.9604) / 
                          (positive + negative)) / (1 + 3.8416 / (positive + negative)) 
       AS ci_lower_bound FROM widgets WHERE positive + negative > 0 
       ORDER BY ci_lower_bound DESC;

Source: evanmiller.org

Similar codes

0 vote270 views2 answers
Mysql regexp match word
SQL
0 vote276 views1 answer
Plsql check for string in numeric
SQL
4 votes264 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote270 views1 answer
Test connection to sql server
SQL
3 votes277 views1 answer
Postgresql db owner change
SQL
8 votes275 views2 answers
Phpmyadmin default password
SQL
0 vote251 views1 answer
Clone table structure mysql
SQL
0 vote268 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote231 views1 answer
'0000-00-00' for column '
SQL
0 vote284 views1 answer
Ajax error exception handeling
SQL