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

28 votes132 views4 answers
Mysql delete database
SQL
0 vote143 views1 answer
Install sql server windows 10
SQL
4 votes142 views3 answers
Sql drop primary key
SQL
11 votes136 views2 answers
Having in sql
SQL
3 votes125 views2 answers
Oracle synonym
SQL
0 vote142 views1 answer
Mysql cast null to string
SQL
0 vote131 views1 answer
T-sql email validation
SQL
0 vote130 views1 answer
Sqlcmd no headers
SQL
10 votes162 views6 answers
Mysql set root password
SQL
0 vote123 views1 answer
Create new table pl sql
SQL