Table: national_parks_elevations
Columns: rank
park
location
peak_name
elevation_ft
minimum_elevation_ft
vertical_relief_ft

Question: What is the mean vertical relief in feet when the rank is more than 40 and the location is va0573?
SQL: SELECT AVG("vertical_relief_ft") FROM national_parks_elevations WHERE "rank" > 40 AND "location" = 'va0573'

Question: What is the total number of ranks when the Peak Name is Red Shirt Table?
SQL: SELECT SUM("rank") FROM national_parks_elevations WHERE "peak_name" = 'red shirt table'