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 vote223 views1 answer
Mysql monthname
SQL
2 votes223 views2 answers
Mysql date range
SQL
6 votes212 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
1 vote229 views1 answer
Mysql select another database
SQL
1 vote244 views1 answer
Sql select max value from multiple rows
SQL
0 vote319 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
5 votes228 views3 answers
Oracle list columns in schema
SQL
0 vote245 views1 answer
Radius search with point data in mysql
SQL
1 vote229 views1 answer
Calculate age in sql postgresql
SQL
2 votes242 views1 answer
Where clause for child record apex
SQL