All language subtitles for 5. Exercise 8 Aggregate functions

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