Re: SQL for a statistic result set

[Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

You're half way there already. CTE the current query and query the CTE 
by max, counting distinct client.

On 09/02/2010 08:32 AM, David FOXWELL wrote:
> Hi all,
> 		
> I have a table like so :
>
> Client Product
> C1		P1
> C1		P2
> C2		P1
> C3		P4
> C4		P1
> C4		P2
> C4		P3
>
> With the max, min and avg functions I can see that on average a client has 2 products, that no client has more than 7 products and none with less than 1.
>
> But how can I output :
>
> Number of products	Number of clients
> 1				?
> 2				
> 3
> 4
> 5
> 6
> 7
>
>
> Thanks.