Cacher is the code snippet organizer for pro developers

\!h Example - percentage of flight distance that is from Delta, by origin:
SELECT     origin, 
    100.0*(sum(CASE WHEN carrier = 'DL' THEN 
distance ELSE 0 END)/sum(distance)) as
percentage_flight_distance_from_delta FROM flights 
GROUP BY origin;