askbug raport for admins

Hello,

Does anyone made or know how to extract the followings from askbug, in order to build a raport:

1. all the anspress participants email addresses
2. total of new users registered during a week
3. the total number of questions posted in a day
4. average number of questions during a week
5. top 3 viewed questions

I’ve tried something directly from mysql database, like:

1. select user_nicename, user_email, user_registered from wp_users;

2. select user_nicename, user_registered from wp_users WHERE user_registered  > (DATE(NOW()) – INTERVAL 7 DAY);

but for the rest of them I’m a little bit confused because (eg. number 3) I got all the posts, not only the questions and so on.

Thanks,