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 vote367 views1 answer
How to find symmetric pairs in sql
SQL
-1 vote370 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote329 views1 answer
How to increase the width of the screen in oracle
SQL
3 votes420 views1 answer
Oracle list invalid password logon denied
SQL
0 vote356 views1 answer
Sql alter table order by
SQL
3 votes343 views1 answer
Mssql remove column
SQL
17 votes337 views6 answers
Sql current date
SQL
10 votes367 views4 answers
Primary key in sql
SQL
1 vote327 views3 answers
String to int mysql
SQL
50 votes425 views6 answers
Sql duplicate rows
SQL