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 vote112 views1 answer
Why mysql is used?
SQL
0 vote124 views1 answer
Add sqlcmd to path linux
SQL
3 votes115 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
12 votes123 views4 answers
Mysql get date difference in hours
SQL
0 vote74 views1 answer
Flask_sqlalchemy install
SQL
0 vote109 views2 answers
MySQL top percent
SQL
12 votes118 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote102 views1 answer
Close sql query vb.net
SQL
2 votes117 views1 answer
Ifnull postgres
SQL
0 vote112 views1 answer
Order by with where clause in mysql
SQL