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 vote151 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote132 views1 answer
How to select only id where is not in column mysql
SQL
0 vote147 views2 answers
What is the default password for sql server sa
SQL
0 vote138 views1 answer
Exectuer myssql .sql
SQL
15 votes144 views6 answers
Laravel db transaction
SQL
1 vote141 views1 answer
Sql padd let with zeros
SQL
6 votes125 views2 answers
Oracle
SQL
0 vote138 views2 answers
How to create a table from another table in sql derby
SQL
15 votes138 views4 answers
Create table if not exists sql
SQL
8 votes124 views3 answers
Duplicate entry
SQL