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

4 votes206 views4 answers
Check constraint in ms sql
SQL
0 vote396 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
2 votes219 views2 answers
How to rename column name in sql server using query
SQL
-1 vote145 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote204 views1 answer
Cast float mysql
SQL
0 vote217 views1 answer
The fetch keyword oracle
SQL
0 vote844 views2 answers
Remove mysql workbench ubuntu
SQL
1 vote192 views1 answer
What is intersect
SQL
0 vote268 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote192 views1 answer
List in one column mysql
SQL