<PLEASE USE THIS TEMPLATE TO HELP YOU CREATE A GREAT POST!>
<Below this line, add a link to the EXACT exercise that you are stuck at.>
<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
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!
100.0 * SUM(CASE WHEN elevation >= 2000
THEN 1 ELSE 0 END) / COUNT(*)
GROUP BY state;
<do not remove the three backticks above>