Hi, thank you or reading:
i am stuck here as well.
100.00 * (sum (CASE WHEN elevation >= 2000 THEN 1 ELSE 0 END) / count(*)) as percentage_high_elevation_airports
group by 1;
i have 2 theories: there are airports outside of USA in the list so the 1st raw is empty >>> i guess i need to ask if the state IS NOT NULL, then it should work...
the other is that the question is % of airports in this state > 2000ft / total # of airports in the country?? here i'm counting # airports in a state that are high to total # of airports in this state..
i am not sure how to fix it