All language subtitles for 12. Exercise 10 Joins

Hi everyone
1

So now we have covered
2

How to get data
3

from two or more tables
4

Using
5

Join statements
6

Let us test If you can get the total sales done in every state
7

For this, use the customer 20 60 and sales 2015 table
8

And for every state find out the total sales value
9

and there is a hint also, to do this you'll need to use both
10

Joins and the group by command
11

For your second activity suppose you want to find out the total sales of each product in your product table
12

So you take your product table and against it
13

Mark the total sales value of that product and total quantity sold of that product
14

So your resultset should have product ID product name category
15

Total sales
16

And
17

Total quantity sold
18

Once you have done this
19

You will be able to use joins whenever you need to
20

If you are facing any difficulty
21

Revisit the joins videos or else ask your doubt in discussion forum