Original subtitles

0 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