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 vote177 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote190 views2 answers
How to save result of sqlite query in a table
SQL
0 vote194 views1 answer
Bitmap join index
SQL
23 votes193 views4 answers
How to uninstall postgresql in ubuntu
SQL
4 votes177 views2 answers
Tsql utf to local time
SQL
0 vote220 views1 answer
Mysql command line top 10
SQL
15 votes185 views2 answers
Open postgress in terminal mac
SQL
2 votes193 views1 answer
Mysql application.properties spring boot
SQL
0 vote222 views1 answer
Virtuoso sql query tutorial
SQL
3 votes282 views1 answer
Oracle show trigger code
SQL