All language subtitles for 3. Exercise 9 Group By

Hi Everyone
1

So we have learnt one of the most important commands in the SQL language, you now know how to group your resultset
2

And get aggregate values against it
3

Let us test If you can get
4

For Each product ID the total sales value in dollars, the total sales quantity
5

So if you remember there is a quantity column
6

I want you to
7

Add up all quantity for each product ID
8

The number of orders for each product ID
9

Maximum sales value
10

Minimum sales value and average sales value for each product ID
11

Once you run this query what you will get is a dashboard that is something what management of this company
12

Would like to see
13

The next activity is to get the list of product IDS where quantity of product sold is greater than
14

10
15

Show with the group by statement
16

There is having
17

Statement
18

Use having to
19

Filter out only those
20

Product IDS where quantity of product sold is more than 10
21

Once you are done this, you will ready to move on to the next lecture