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 vote313 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote305 views1 answer
Sql tablo sp
SQL
0 vote294 views1 answer
How get data from database if id not found then search another column
SQL
0 vote285 views1 answer
Sql server whoami
SQL
0 vote295 views1 answer
How to connect postgresql database with java
SQL
2 votes288 views1 answer
Oracle find unusable indexes
SQL
0 vote340 views1 answer
Remove mysql from centos 7
SQL
2 votes304 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote305 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote342 views1 answer
Différence entre deux dates sql oracle
SQL