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.