Hello, I just want to know what the forward slash [ / COUNT(*) ] in the answer for this exercise is used for? It's the first time I've seen it anywhere. If I had to guess it's for division, but I've been wrong a lot with SQL. Thank you!
SELECT state, 100.0 * SUM(CASE WHEN elevation >= 2000 THEN 1 ELSE 0 END) / COUNT(*) as percentage_high_elevation_airports FROM airports GROUP BY state;