1
00:00:00,150 --> 00:00:05,190
The last thing I'll show you before we get to the exercise for this section is where you can find a

2
00:00:05,190 --> 00:00:08,220
list on the docs of the different aggregate functions.

3
00:00:08,250 --> 00:00:13,260
I've covered all the ones that are common, I would say, or almost all of them.

4
00:00:13,260 --> 00:00:20,520
So we have average and count max and min some, but there are others in here and some of these you probably

5
00:00:20,520 --> 00:00:25,800
won't ever need to worry about like bit or which is bitwise or or bitwise.

6
00:00:25,800 --> 00:00:30,990
And you probably don't need to worry about JSON array AG for now.

7
00:00:30,990 --> 00:00:36,480
JSON object AG one though that may come up is STD.

8
00:00:36,720 --> 00:00:37,230
Yes.

9
00:00:37,230 --> 00:00:40,320
I'm telling you, you might actually want an STD.

10
00:00:40,350 --> 00:00:42,480
It's for standard deviation.

11
00:00:42,930 --> 00:00:46,320
I figured it's probably not worth showing at this point.

12
00:00:46,320 --> 00:00:51,090
If you know about standard deviation and it's something that you would want to use in some analysis,

13
00:00:51,090 --> 00:00:53,130
well, it's here for you to use.

14
00:00:53,130 --> 00:00:57,510
It works the same way as all the other aggregate functions I've shown you, except, of course, it

15
00:00:57,510 --> 00:01:03,060
returns standard deviation, not average or sum or max or min or count.

16
00:01:03,060 --> 00:01:04,769
So there are some other examples.

17
00:01:04,920 --> 00:01:09,000
A lot of them have to do with standard deviation as well, but that's pretty much it.

18
00:01:09,000 --> 00:01:11,280
We've covered the real important ones.

19
00:01:11,280 --> 00:01:14,280
Some count average, Min and max.

20
00:01:14,430 --> 00:01:17,040
All right, next up, we've got some practice.