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 vote140 views1 answer
Mysql readable output
SQL
0 vote115 views1 answer
C# execute transact sql
SQL
1 vote103 views1 answer
SQLSTATE[HY000] [2002]
SQL
1 vote126 views1 answer
Get current date in pyspark sql
SQL
0 vote132 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote120 views1 answer
Sql injection payload list github
SQL
2 votes105 views1 answer
Set column to not null mysql
SQL
8 votes102 views2 answers
Phpmyadmin default password
SQL
3 votes104 views2 answers
Tsql join multiple record in one string
SQL
0 vote100 views1 answer
Mysql grant all on all databases
SQL