Tabular Form Out Put

Could you please help me to get the expected out put .

here is the sample


Create Table Inventory

(

Item Varchar(10),

Color Varchar(10),

Quantity int

)

Insert Into Inventory Values('Table','Blue',124)

Insert Into Inventory Values

('Table','Red',223)

Insert Into Inventory Values ('Chair','Blue',101)

Insert Into Inventory Values ('Chair','Red',210)

Insert Into Inventory Values ('Chair','Red',230)


Expected output


Blue red

table 1 1

Chair 1 2

Total 2 3