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

3 votes192 views1 answer
Index using in query plsql
SQL
7 votes182 views3 answers
How ot change name of column mysql
SQL
0 vote191 views1 answer
How to find username and password in oracle 18c
SQL
1 vote192 views1 answer
Sql how to duplicate a table
SQL
5 votes172 views2 answers
Create table
SQL
0 vote203 views1 answer
Modifier une valeur sql
SQL
0 vote246 views1 answer
Postgres foreign key multiple columns
SQL
0 vote195 views1 answer
Joins vs includes
SQL
0 vote224 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote186 views1 answer
Delete double on SQL with multiple primary keys
SQL