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 vote200 views1 answer
Sql select all tables from database change url
SQL
2 votes320 views2 answers
MySql FULL OUTER JOIN
SQL
-1 vote201 views3 answers
MySQL shutdown unexpectedly
SQL
1 vote224 views2 answers
Drop table with constraints
SQL
1 vote201 views1 answer
Oracle case
SQL
0 vote201 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote169 views2 answers
Delete the last item in a table sql
SQL
7 votes276 views2 answers
Phpmyadmin change password
SQL
0 vote204 views1 answer
C# execute transact sql
SQL
6 votes202 views3 answers
Oracle all dates between two dates
SQL