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 vote317 views4 answers
How to connect form to database
SQL
1 vote318 views1 answer
Mysql select if empty result
SQL
1 vote350 views1 answer
Mysql login console
SQL
5 votes306 views1 answer
Oracle columns in all_tables
SQL
3 votes360 views1 answer
Mysql group_concat distinct
SQL
13 votes301 views3 answers
Sql online code
SQL
0 vote300 views1 answer
Mysql delete from where like
SQL
-1 vote357 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote317 views1 answer
Mysql bind-address default value
SQL
6 votes343 views2 answers
Sql sequence
SQL