Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Conditional Aggregates

Combining aggregates

Oftentimes we'd like to combine aggregates, to create percentages or ratios.

In the instance of the last query, we might want to find out the percent of flight distance that is from United by origin airport. We can do this simply by using the mathematical operators we need in SQL:

SELECT origin, 100.0*(sum(CASE WHEN carrier = 'UN' THEN distance ELSE 0 END)/sum(distance)) as percentage_flight_distance_from_united FROM flights GROUP BY origin;
Report a Bug
If you see a bug or any other issue with this page, please report it here.