I have completed this exercise however I'm confused about the then 1 part, I'm assuming it means count all the flights below 1000 ft and then skip one before ending the query? I'm probably completely off but can someone enlighten me? Thanks.
SELECT state, COUNT(CASE WHEN elevation < 1000 THEN 1 ELSE NULL END) as count_low_elevation_aiports FROM airports GROUP BY state;
*Using Chrome, Windows 10.