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 vote241 views1 answer
Import all databases mysql
SQL
9 votes287 views2 answers
SELECT User,Host FROM mysql.user;
SQL
32 votes277 views6 answers
Sql count where
SQL
0 vote280 views1 answer
Bidirectional outer join sql
SQL
0 vote271 views1 answer
Delete record by id sql
SQL
0 vote259 views1 answer
Mysql Error Code: 1005
SQL
2 votes268 views2 answers
How to create an empty table from an existing table
SQL
0 vote279 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote312 views1 answer
Sql alternative to max statement
SQL
1 vote297 views2 answers
Install sql server management studio ubuntu
SQL