Learn

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.

Sign up to start coding

By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Already have an account?