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

1 vote125 views1 answer
Reutrn string after character sql
SQL
5 votes147 views1 answer
Oracle list days between two dates
SQL
1 vote144 views1 answer
Psql import backup file for windows
SQL
17 votes164 views6 answers
Get last record in sql
SQL
0 vote127 views2 answers
Show slave status mysql
SQL
-2 votes147 views2 answers
Union all in sql
SQL
3 votes128 views1 answer
Postgres update column with value from another table
SQL
1 vote134 views1 answer
Mysql current time
SQL
11 votes125 views1 answer
Oracle insert into where
SQL
5 votes149 views1 answer
Mysql last day of next month
SQL