INSTRUCTOR: In the previous tutorial, I did a really simple totals query or aggregate query. In this tutorial here, I'm going to just take it a little step further. And I'm going to, again, look at the categories and films table. And I'm just going to feed in a particular category here, which I want to group by. 

And also, I'm going to focus, really, on two different fields down here that are number based, so the review and the runtime. And I'm going to flick on my totals or aggregate icon. And what I want to do is I want to group by all the categories, but for the review and the runtime, well, I want to instead of counting the reviews, which wouldn't make much sense, I want to get the average review of the different films and the different categories. 

So give me the average review of all the westerns, of all the science fiction, of all the horrors, et cetera. And then in the runtimes, well, let's consider the scenario of whether that we might want the average runtime, the maximum, and the minimum runtimes as well. And there's no problem to do that, to actually add in the field a number of different times. 

So, like I said, I'll take the average here. And I'll add in the runtime field again and again. And I'm going to put in the min and the max of all of those different runtimes. And I'm going to get each of those different figures for the runtimes of all the different films and the different categories. 

So I can layer it up any way that I want. And I'm going to run this query. Let's just take a look at what's happening. Now, any time that we see these hash symbols come across the screen, that usually means that we've got a lot of decimal places. And we'll talk about how we can solve that in a minute. But we can see the actual numbers coming out here-- average review, average runtime, the minimum runtime, and the maximum runtime of all of the different films in the different categories. 

Now, the decimal point problem, if we can go back there into the design. And I'm going to go into either of those different average columns that I had created. And I will look at the property sheet for that. And what I have to do is the two-stage process here to manage the different decimal places. I have to set the format for something. And usually, it's either fixed or standard if it's just a basic number. 

And so I'll go fixed. And then I set the number of decimal places that I want. So let's say I just want one decimal place. And I'll do the same for this average runtime as well. I'll set it to fixed and one decimal place. And let's see that work. 

And so we get the a much more tidy type of dynaset for the query result. And that gives you an overall picture of some more advanced totals queries. Don't forget to like or share this video if you found it useful.