Hi all, i'm new to SQL and was wondering if anyone can advise on how to count the number of times each number in the count column appears? For example the answer would be 4 for the number of times 3 appears and 5 for the number of times 2 appears. I'm working in Business Objects so can create a separate variable and show the answer in a separate table. I appreciate this is an excel forum so any advise would be greatly appreciated.