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
.