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

8 votes140 views2 answers
Between operator
SQL
0 vote139 views1 answer
Date datatype in livesql
SQL
0 vote104 views0 answer
SQL
0 vote151 views2 answers
List all constraints in postgres
SQL
4 votes175 views2 answers
Oracle unliock account
SQL
8 votes189 views2 answers
Default sql server port
SQL
0 vote158 views2 answers
Postgres having
SQL
3 votes144 views1 answer
Oracle sleep
SQL
0 vote177 views2 answers
Suse stop MySQL
SQL
0 vote647 views1 answer
Sql show table name in result
SQL