Learn
Conditional Aggregates
Combining aggregates II

Modify the previous elevation example to find the percentage of high elevation airports (elevation >= 2000) by state.

Instructions

1.

Find the percentage of high elevation airports (elevation >= 2000) by state from the airports table.

In the query, alias the percentage column as percentage_high_elevation_airports.

Folder Icon

Sign up to start coding

Already have an account?