0

I have the following table:

NAME
------
Alex
Bob 
Bob
Tim
Alex
Roger

I need to produce the following:

 Name    Count Percentage
 -------------------------
 Alex    2     33%
 Bob     2     33%
 Roger   1     16.6%
 Tim     1     16.6%

I have no idea where to start. I can do the initial query for the count which is simple.

0

0

Browse other questions tagged or ask your own question.