Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Conditional Aggregates


Sometimes you want to look at an entire result set, but want to implement conditions on certain aggregates.

For instance, maybe you want to identify the total amount of airports as well as the total amount of airports with high elevation in the same result set. We can accomplish this by putting a CASE WHEN statement in the aggregate.

SELECT state, COUNT(CASE WHEN elevation >= 2000 THEN 1 ELSE NULL END) as count_high_elevation_aiports FROM airports GROUP BY state;
Report a Bug
If you see a bug or any other issue with this page, please report it here.