Start by ...
.. to count the web casts per person.Code:select fname||lname||email unq_person, count(distinct web_cast_name) wc_views group by fname||lname||email
Then ...
.. to count the number of people per number of viewsCode: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
There's a start for you, anyway.




Reply With Quote