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

16 votes143 views2 answers
Add column if not exists mysql
SQL
0 vote147 views1 answer
Mysqlimport
SQL
0 vote150 views1 answer
Drop database using terminal postgres
SQL
0 vote140 views1 answer
Display first three characters sql
SQL
8 votes141 views1 answer
Sql remove leading spaces
SQL
0 vote160 views1 answer
Connecting mySQL to STS
SQL
0 vote153 views1 answer
Sql last 3 rows
SQL
3 votes162 views1 answer
Sql select second max
SQL
1 vote127 views1 answer
Can not connect to mysql server
SQL
1 vote146 views1 answer
Moodle query first user access
SQL