I know it's too late to ask but what does group by do?


#1


https://www.codecademy.com/en/courses/sql-table-transformation/lessons/conditional-aggregates/exercises/case-when?action=lesson_resume&link_content_target=interstitial_lesson


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



SELECT
    CASE
        WHEN elevation < 250 THEN 'Low'
        WHEN elevation BETWEEN 250 AND 1749 THEN 'Medium'
        WHEN elevation >= 1750 THEN 'High'
        ELSE 'Unknown'
    END AS elevation_tier
    , COUNT(*)
FROM airports
GROUP BY 1;


#2

I don't know the exact answer but I think it's sorting the rows by the thing that we give him. Am I right? or maybe I'm just confused with order by and group by!
*Sorry for my English


#3

http://www.tutorialspoint.com/sql/sql-group-by.htm


#4

Thank you.
It was helpful.


#5

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