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 vote272 views1 answer
Sql cross apply vs join
SQL
0 vote324 views2 answers
Mysql insert into multiple tables
SQL
19 votes285 views2 answers
Mysql add column after another
SQL
1 vote281 views1 answer
Mysql show long running queries
SQL
0 vote290 views1 answer
Alter fedora mysql 8.0 user
SQL
3 votes300 views1 answer
DB: in eloquent using sql
SQL
0 vote280 views1 answer
Postgresql alter column nullable
SQL
9 votes276 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote312 views1 answer
Database Queries
SQL
1 vote286 views1 answer
How to delete a record from sqlite in android
SQL