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 vote165 views1 answer
Postgres grant read only access to database
SQL
29 votes202 views6 answers
Delete all rows from table mysql
SQL
1 vote224 views1 answer
Floor function in sql oracle
SQL
0 vote211 views1 answer
Python connect microsoft sql server
SQL
1 vote200 views1 answer
Temp table vs variable table in sql server
SQL
0 vote205 views1 answer
Equi joins in oracle
SQL
0 vote195 views1 answer
Copy data from cell to cell mysql
SQL
2 votes203 views3 answers
Postgresql reset auto increment
SQL
10 votes224 views2 answers
Doublon sql
SQL
0 vote201 views1 answer
Acual month sql
SQL