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 vote242 views1 answer
What is the difference between now() and current_date()?
SQL
5 votes218 views1 answer
Oracle asynchronous procedure
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
1 vote223 views1 answer
Select not matching data from two tables
SQL
1 vote192 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote347 views1 answer
Postgresql powershell query
SQL
0 vote239 views1 answer
Login failed for user sql server
SQL
0 vote239 views1 answer
Psql attribute cannot login
SQL
0 vote250 views1 answer
Postgresql delete limit
SQL
1 vote253 views1 answer
Postgres set sequence value to max id
SQL