PLEASE DELETE this thread. I solved how to do it and get averages and so on. I was real tired from programing 5 days straight with just a few power naps and made this sily post about sql query. If someone would like the code to be able to display group stats like: album count, picture count, users, average picture per user, average file size per pic from this group, etc list goes on. I use it to help monitor each group and if I should raise the groups limits overall or just a few. It is also used for other users to see there stats compared to others.