Errors in the high-elevation query

<Below this line, add a link to the EXACT exercise that you are stuck at.>

This is one of the questions in the conditional aggregate
Find the percentage of high elevation airports (elevation >= 2000) by state from the airports table.
<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
The error is given like this:
Find the percentage of high elevation airports by state.
<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>
Can anyone tell what’s wrong with my code? Thank you!

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

select state, 100.0 * (sum(case when elevation >= 2000 then 1 else 0 end)/sum(elevation)) as percentage_high_elevation_airports
from airports
group by state;

```
``<do not remove the three backticks above>``

An average would imply dividing by a count. The sum is in the numerator.

I don’t quite get your point. Would you like to clarify it?

``````... / count(*)
``````

Unfortunately, there is still something wrong after I tried your way…

The table won’t be drawn if the SCT fails. The SQL might be right. Let’s fiddle with the inputs and see how the SCT responds.

`select state, 100.0 * sum(case when elevation >= 2000 then 1 else 0 end) / count(*)`

What does this result in?

no from… gives me error again.
The case syntax gives me a binary result. Is it the error come from the sum(binary results)?

2 posts were split to a new topic: Stuck on high elevation

Be sure you haven’t removed the rest of your code. The above is what goes before AS.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.