Original subtitles

0 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