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 vote192 views1 answer
Sparql list all graphs
SQL
0 vote176 views1 answer
Wp_query raw sql
SQL
0 vote179 views1 answer
Postgresql heritage
SQL
0 vote199 views1 answer
T-SQL Never ending DELETE
SQL
0 vote171 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote176 views1 answer
How to select random rows from table
SQL
0 vote253 views1 answer
Sql alter table add column if exists
SQL
0 vote248 views1 answer
Opensuse start MySQL
SQL
11 votes203 views1 answer
How to get ddl for materialized view
SQL
3 votes176 views1 answer
Oracle list user grants
SQL