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

22 votes334 views3 answers
Remove all records from table mysql
SQL
0 vote323 views1 answer
Show table structure mysql console
SQL
0 vote318 views1 answer
Output table plsql
SQL
5 votes324 views1 answer
How to check nls format in oracle
SQL
0 vote321 views1 answer
Mysql config slave
SQL
0 vote333 views1 answer
Call function sql oracle with output put line
SQL
11 votes352 views2 answers
Oracle saurce code
SQL
-1 vote322 views3 answers
Mysql get age from date
SQL
1 vote352 views1 answer
Psql view enum values
SQL
0 vote354 views1 answer
How to check database engine in mysql
SQL