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 vote147 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
3 votes168 views4 answers
Truncate syntax in sql
SQL
0 vote157 views2 answers
Oracle chain rules
SQL
51 votes261 views6 answers
Opera gx
SQL
0 vote161 views1 answer
Java nosql sort
SQL
1 vote157 views1 answer
Add many column to sap iq table
SQL
0 vote156 views4 answers
How to connect form to database
SQL
-1 vote104 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote150 views1 answer
Python escape mysql
SQL
2 votes164 views2 answers
How to rename column name in sql server using query
SQL