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

3 votes411 views1 answer
Unsigned int in mysql
SQL
0 vote374 views1 answer
Sql get latest of 2 datetimes
SQL
1 vote373 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote363 views1 answer
Initcap in sql
SQL
104 votes575 views2 answers
Like in mysql
SQL
1 vote389 views1 answer
Table valued functions in sql
SQL
0 vote303 views1 answer
Update sql join multiple tables
SQL
-2 votes383 views4 answers
How to get max salary in each department in sql
SQL
0 vote365 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote388 views1 answer
Sql set auto increment back to 0
SQL