Example query for sorting an SQL table by average rating

average_rating.sql

SELECT 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 some_table 
    WHERE positive + negative > 0
 ORDER BY ci_lower_bound DESC;