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 vote363 views1 answer
Mysql page segment
SQL
3 votes370 views2 answers
Sql end of month
SQL
0 vote375 views1 answer
Sql filter rows with condition
SQL
1 vote370 views1 answer
Increase existing date in sql
SQL
0 vote345 views1 answer
Cast as decimal postgresql
SQL
0 vote409 views1 answer
Mysql concatenate select results
SQL
0 vote333 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote355 views1 answer
Postgresql not in alternative
SQL
3 votes329 views1 answer
Sql select all
SQL
0 vote332 views1 answer
Redirection 301 htaccess nom de domaine
SQL