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



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:

        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


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




Thank you.
It was helpful.


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