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 vote176 views2 answers
Update with inner join sql server
SQL
0 vote183 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote194 views2 answers
Call to undefined function mysql_query()
SQL
1 vote152 views1 answer
Avg mysql
SQL
0 vote190 views1 answer
Sql server phone constraint
SQL
0 vote128 views1 answer
Sql count how many times a value appears
SQL
3 votes206 views5 answers
Duplicate table sql
SQL
1 vote189 views1 answer
T-SQL Alter the column data type
SQL
0 vote187 views1 answer
Plsql find location of procedure
SQL
0 vote185 views1 answer
Tsql table column constraint must be uppercase
SQL