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

0 vote113 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote111 views1 answer
Oracle search columns in schema
SQL
12 votes114 views4 answers
How to take database dump in postgresql
SQL
5 votes109 views1 answer
Mysql get last day of month
SQL
0 vote120 views1 answer
Comma seperated join mssql
SQL
0 vote113 views1 answer
Pl/sql loop example
SQL
2 votes120 views1 answer
Sql server check for value in multiple columns
SQL
0 vote114 views1 answer
Sqlalchemy query sql compiled
SQL
10 votes67 views1 answer
Oracle view dependencies
SQL
3 votes167 views1 answer
Sql add two values together
SQL