-
analytical stats query
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
-
Start by ...
Code:
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 ...
Code:
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|