<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 don’t understand what does the group by do?
I know it’s not the time to ask this but please can anyone explain for me? For example what does the group by do in this code?
Thanks in advance for any feedback.
<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.>
WHEN elevation < 250 THEN ‘Low’
WHEN elevation BETWEEN 250 AND 1749 THEN ‘Medium’
WHEN elevation >= 1750 THEN ‘High’
END AS elevation_tier
GROUP BY 1;
<do not remove the three backticks above>