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 vote161 views1 answer
Hw to delete a procedure in pl sql
SQL
37 votes211 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote183 views1 answer
Print all records of table in mysql
SQL
3 votes164 views4 answers
Show sql server database
SQL
-1 vote212 views1 answer
Partial search in sql
SQL
1 vote167 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote596 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote213 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote170 views1 answer
MySQL error code 2068
SQL
1 vote182 views1 answer
Customer using hdfc bank sql query
SQL