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 vote295 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
7 votes186 views1 answer
Safe mode mysql
SQL
0 vote200 views1 answer
Mysql subdate
SQL
2 votes228 views1 answer
Sql percentage with % rounded down
SQL
0 vote210 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
2 votes248 views1 answer
Create delete procedure mysql
SQL
4 votes197 views1 answer
Select nls_date_format
SQL
0 vote208 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote228 views1 answer
Sqlcmd no headers
SQL
5 votes195 views1 answer
Postgresql functions
SQL