The difference in () and (())

<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.>
EXERCISE 7 Combining Aggregate. The difference is the extra bracket. Why does the two results differ?

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>

<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.>

<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 ) / COUNT (*) as percentage_high_elevation_airports FROM airports GROUP BY state

SELECT STATE, 100*(SUM(CASE WHEN elevation >=2000 THEN 1 ELSE 0 END)/ COUNT(*))
percentage_high_elevation_airports
FROM airports
GROUP BY STATE

<do not remove the three backticks above>

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