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

7 votes167 views3 answers
Postgre describe table
SQL
22 votes183 views3 answers
SQL CHEATSHEET
SQL
4 votes191 views6 answers
List all tables in postgres
SQL
0 vote187 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote175 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote163 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote173 views1 answer
Sqlalchemy query return only n results
SQL
2 votes168 views1 answer
Enum in SQL Server
SQL
0 vote161 views2 answers
Mysql multiply
SQL
0 vote179 views1 answer
Mysql type for large numbers with many decimal
SQL