analytical stats query

[rkiss]

Hi,

I have to create a report that shows number of people attending web casts.

I need to show the following:

# of people saw 1 web cast:
# of people that saw more than one web cast:
# of peoople that saw more than 2 web cast:
.
.
.
# of people that saw more than n web casts:
---------------------------------------------------------

I have a table called web_casts with the following attributes:

web_cast_name,
fname,
lname,
email
-------------------------------------------------------------


Thanks for all the help

[slimdave]

Start by ...

select fname||lname||email unq_person,
 count(distinct web_cast_name) wc_views
group by fname||lname||email

.. to count the web casts per person.

Then ...

select wc_views,count(*) persons
from
(
select fname||lname||email unq_person,
 count(distinct web_cast_name) wc_views
group by fname||lname||email
)
group by wc_views

.. to count the number of people per number of views
There's a start for you, anyway.

[rkiss]

thanks slimdave