All language subtitles for 3. AVERAGE

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