Hi I am new to the Toad World – Would like to get some help on below.----SELECT TABLE1.PRODUCTID, TABLE1.TYPE , TABLE1.PRODUCT, TABLE2.#SOLD FROM TR.TABLE1 INNER JOIN* PR.TABLE2** ON (TR. PRODUCTID = PRODUCTID )** When we merge the above two table…The query result will look like this:
Product ID
Product
Type
#Sold
1
Fruit
Banana
2
2
Food
Rice
2
3
Food
Sugar
6
4
Fruit
Orange
8
5
Fruit
Apple
10
6
Food
Sugar
12
7
Food
Corn
3
8
Fruit
Apple
5
9
Fruit
Banana
7
10
Food
Sugar
1
11
Fruit
Banana
5
12
Food
Sugar
7 ** *
Now I want manipulate the query further and create three new columns from ‘#Sold’
Product
Type
#Sold
Group 0 -3 (# sold)
Group 4-9 (#sold)
Group > 10 (*sold)
Total #Sold
Corn
3
1
Rice
2
1
Sugar
6
1
1
Sugar
12
Sugar
1
1
Sugar
7
1
Food
6
Apple
10
1
Apple
5
1
Banana
5
1
Banana
7
1
Banana
question.docx (17.4 KB)