The last thing I'll show you before we get to the exercise for this section is where you can find a
list on the docs of the different aggregate functions.
I've covered all the ones that are common, I would say, or almost all of them.
So we have average and count max and min some, but there are others in here and some of these you probably
won't ever need to worry about like bit or which is bitwise or or bitwise.
And you probably don't need to worry about JSON array AG for now.
JSON object AG one though that may come up is STD.
Yes.
I'm telling you, you might actually want an STD.
It's for standard deviation.
I figured it's probably not worth showing at this point.
If you know about standard deviation and it's something that you would want to use in some analysis,
well, it's here for you to use.
It works the same way as all the other aggregate functions I've shown you, except, of course, it
returns standard deviation, not average or sum or max or min or count.
So there are some other examples.
A lot of them have to do with standard deviation as well, but that's pretty much it.
We've covered the real important ones.
Some count average, Min and max.
All right, next up, we've got some practice.