Original subtitles

0 Now, Let us look at the average function 1

Average as you must be knowing is the average or the mean value of all the values that we have 2

provided as an input 3

So if you want to get average of any particular column 4

We'll use 5

AVG 6

Which is the average function 7

The syntax of this is, select 8

AVG 9

Mention the column name 10

You can mention other column names also there, after this from tablename 11

And you can specify condition using the where 12

If you want to 13

Let us look at some examples 14

Suppose you want to find out what is the average age of the customers 15

Who are buying 16

At our Store 17

To do that we'll write select 18

Average age 19

As Average customer age 20

From the customer table, So let us go and write this query 21

Select AVG age, This is the column 22

Of which I want to get the average, as average customer age 23

From the customer table 24

Let us run this 25

The average age of customer who is coming to our Store 26

Is 27

44 years 28

Now, suppose we want to find out average commission I am paying 29

Per order 30

For every order, if I am paying out 31

10% of the sales value as Commission 32

So average Commission will be average of the total sales into 10% 33

To do that, we will write select 34

AVG 35

Sales into 10% as average Commission value from sales 36

Let's go and write this query 37

Select 38

AVG 39

Sales into 10% into 0.10 40

0.10 41

As average Commission value 42

From the sales table 43

You can see 44

It will find the total of sales into 10% and then save it as average and the average 45

Commission I am paying is 22.9 units 46

This is how we use the average 47

Function, next we'll look at the min and max functions