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 votes346 views1 answer
Set default today mysql
SQL
-1 vote296 views10 answers
Delete Query in SQL Server
SQL
0 vote333 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote333 views1 answer
Mysql monthname
SQL
3 votes390 views2 answers
Savepoint in sql
SQL
2 votes334 views3 answers
How to pass password mysql command line
SQL
-1 vote366 views1 answer
Mysql faster insert
SQL
2 votes368 views1 answer
Sql server find columns list in tables
SQL
4 votes370 views2 answers
Sqlalchemy_database_uri for mysql
SQL
3 votes350 views1 answer
How to find names includes in sql
SQL