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 votes286 views1 answer
Sql is not like
SQL
4 votes269 views1 answer
Postgresql change default value
SQL
0 vote264 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote306 views1 answer
Python sql last insertend
SQL
0 vote284 views1 answer
Mysql select inside sum
SQL
1 vote299 views5 answers
What is in operator in sql
SQL
0 vote318 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote304 views2 answers
Select last 30 days sql
SQL
2 votes272 views1 answer
Oracle list grants on procedure
SQL
23 votes281 views1 answer
How remove column in mysql
SQL