Manipulate Query Further / Create Three New Columns?

I am new to the Toad World �
----
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 IDProductType#Sold
1FruitBanana2
2FoodRice2
3FoodSugar6
4FruitOrange8

[code]...

Now I want manipulate the query further and create three new columns from �#Sold�

ProductType#SoldGroup 0 -3 (# sold)Group 4-9 (#sold)Group > 10 (*sold)Total #Sold
Corn31
Rice21
Sugar611
Sugar12
Sugar11

[code]...

Is it Possible to twist the below code to produce the above
SELECT TABLE1.PRODUCTID, TABLE1.TYPE , TABLE1.PRODUCT, TABLE2.#SOLD
FROM TR.TABLE1
INNER JOIN
PR.TABLE2
ON (TR. PRODUCTID = PRODUCTID )