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

1 vote319 views3 answers
Grant syntax in sql
SQL
0 vote347 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
1 vote346 views1 answer
Mysql drop key
SQL
0 vote350 views1 answer
Apex for oracle 11g
SQL
2 votes355 views1 answer
Coalesce sql
SQL
7 votes368 views1 answer
Show line number in sql server
SQL
0 vote324 views1 answer
Postgresql import a database of gzip
SQL
1 vote341 views1 answer
Woocommerce mysql price table
SQL
3 votes347 views3 answers
Raw select laravel
SQL
0 vote338 views1 answer
Sql server udf performance
SQL