hi all
I have a table with 3 columns one is customer name and the other itemid and item color and I want to know for each customer how many items he has and which color how can I make it in a sql command


thanx