All good info, and I hate to be a pain, but:

SELECT
...
calls_received+num_paid_emails-calls_failed) activity,
username, length
...
FROM

...still doesn't tell me where all the columns come from. I'd like to abstract some of the tables to outside of the WHERE ROWNUM clause, but to do that I need to know where all the columns come from...

Thanks,

- Chris