Original subtitles

0 Hi Everyone 1

Now we have learnt the aggregate functions 2

In aggregate functions we learnt five main types of functions, one is sum, one is count, then 3

Average, then minimum and maximum 4

Now 5

Let us try to find out what is the sum of all sales 6

That I have done 7

So I want you to go and find out 8

Total value of sales that we have done from the sales table 9

Next I want you to get the count of customers 10

Who are living in North region 11

With age between 20 and 30 12

Maybe 13

In the north region you want to start a marketing campaign towards the young population 14

And you want to find out the count of customers you will be 15

Aiming at 16

Let us find out the count of customers in North region between age 20 and 30 17

Next 18

Let us find out the average age of customers in the east region 19

Lastly 20

Find out the minimum and maximum age customer 21

From the city Philadelphia 22

Once you do all these four activities 23

Will be comfortable with the aggregate functions 24

And you'll be ready with the 25

Next video lecture