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 vote249 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote316 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes251 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote254 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
5 votes257 views1 answer
AND OR NOT operators sql
SQL
0 vote239 views1 answer
Trim sql oracle
SQL
0 vote241 views1 answer
Pl sql search saurce code
SQL
1 vote270 views1 answer
Postgresql not in
SQL
0 vote254 views1 answer
What is the use of index in mysql table
SQL
7 votes259 views1 answer
Sql server convert string to date
SQL