Top 20 groups with the most members: [quote][url=http://www.bungie.net/en/Groups/Detail?groupId=3656]The Spartan I Project[/url] - 10,382 [url=http://www.bungie.net/en/Groups/Detail?groupId=8263]Coup D Bungie[/url] - 6,566 [url=http://www.bungie.net/en/Groups/Detail?groupId=2442]The Bungie Podcast[/url] - 4,467 [url=http://www.bungie.net/en/Groups/Detail?groupId=293]Mjolnir Battle Tactics[/url] - 3,563 [url=http://www.bungie.net/en/Groups/Detail?groupId=2302]Owners of the Katana[/url] - 3,272 [url=http://www.bungie.net/en/Groups/Detail?groupId=16555]Destiny[/url] - 2,800 [url=http://www.bungie.net/en/Groups/Detail?groupId=2812]Facility B5D[/url] - 1,704 [url=http://www.bungie.net/en/Groups/Detail?groupId=12337]Sapphire[/url] - 1,342 [url=http://www.bungie.net/en/Groups/Detail?groupId=13461]Minecrafters[/url] - 1,021 [url=http://www.bungie.net/en/Groups/Detail?groupId=602]KOTOR[/url] - 987 [url=http://www.bungie.net/en/Groups/Detail?groupId=3338]HLG[/url] - 926 [url=http://www.bungie.net/en/Groups/Detail?groupId=10888]Ask Your Ninja[/url] - 850 [url=http://www.bungie.net/en/Groups/Detail?groupId=18533]TFS The Floods Sanctuary[/url] - 699 [url=http://www.bungie.net/en/Groups/Detail?groupId=3493]Mythic Members[/url] - 661 [url=http://www.bungie.net/en/Groups/Detail?groupId=19291]The Bird People[/url] - 657 [url=http://www.bungie.net/en/Groups/Detail?groupId=19014]Halo Forum[/url] - 650 [url=http://www.bungie.net/en/Groups/Detail?groupId=16959]Secular Sevens[/url] - 649 [url=http://www.bungie.net/en/Groups/Detail?groupId=8896]UNSC Leviathan[/url] - 603 [url=http://www.bungie.net/en/Groups/Detail?groupId=15287]The Community Carnage[/url] - 603 [url=http://www.bungie.net/en/Groups/Detail?groupId=17487]Cafe[/url] - 581[/quote][spoiler]select concat( '[url=http://www.bungie.net/en/Groups/Detail?groupId=', g.groupId, ']', g.name, '[/url] - ', format(g.memberCount, 0) ) from bungie.groups g order by g.memberCount desc limit 0, 20;[/spoiler] Average number of members a group has: 43[spoiler]select format(floor(avg(g.memberCount)), 0) from bungie.groups g;[/spoiler] Average number of followers as group has: 51[spoiler]select format(floor(avg(g.followerCount)), 0) from bungie.groups g;[/spoiler] Number of groups with pending members: 123[spoiler]select format(count(*), 0) from bungie.groups g where g.pendingMemberCount > 0;[/spoiler] Top 20 groups with most pending members: [quote][url=http://www.bungie.net/en/Groups/Detail?groupId=3656]The Spartan I Project[/url] - 841 [url=http://www.bungie.net/en/Groups/Detail?groupId=18405]Welcoming Committee[/url] - 69 [url=http://www.bungie.net/en/Groups/Detail?groupId=2302]Owners of the Katana[/url] - 65 [url=http://www.bungie.net/en/Groups/Detail?groupId=39873]The 117th Regiment[/url] - 17 [url=http://www.bungie.net/en/Groups/Detail?groupId=12]Mob of Angry Peasants[/url] - 11 [url=http://www.bungie.net/en/Groups/Detail?groupId=12839]The WorkPLace[/url] - 11 [url=http://www.bungie.net/en/Groups/Detail?groupId=39813]Art and Stuff[/url] - 9 [url=http://www.bungie.net/en/Groups/Detail?groupId=12088]The Anime Community[/url] - 9 [url=http://www.bungie.net/en/Groups/Detail?groupId=12337]Sapphire[/url] - 9 [url=http://www.bungie.net/en/Groups/Detail?groupId=39834]Destiny on Wii U[/url] - 8 [url=http://www.bungie.net/en/Groups/Detail?groupId=62257]Destiny beta[/url] - 7 [url=http://www.bungie.net/en/Groups/Detail?groupId=61944]The Lone Wolves Pack[/url] - 6 [url=http://www.bungie.net/en/Groups/Detail?groupId=40360]Trinity[/url] - 5 [url=http://www.bungie.net/en/Groups/Detail?groupId=40465]Rogue Ops[/url] - 4 [url=http://www.bungie.net/en/Groups/Detail?groupId=39601]The Guardians of Destiny[/url] - 4 [url=http://www.bungie.net/en/Groups/Detail?groupId=41706]Lurulu[/url] - 4 [url=http://www.bungie.net/en/Groups/Detail?groupId=41199]AlienNerds[/url] - 3 [url=http://www.bungie.net/en/Groups/Detail?groupId=39785]KSI National[/url] - 3 [url=http://www.bungie.net/en/Groups/Detail?groupId=41360]Destiny Gamers in PS4[/url] - 3 [url=http://www.bungie.net/en/Groups/Detail?groupId=41418]Huntresses[/url] - 3[/quote][spoiler]select concat( '[url=http://www.bungie.net/en/Groups/Detail?groupId=', g.groupId, ']', g.name, '[/url] - ', format(g.pendingMemberCount, 0) ) from bungie.groups g order by g.pendingMemberCount desc limit 0, 20;[/spoiler] Number of groups where the current founder is not the user who created it: 159[spoiler]select format(count(*), 0) from bungie.groups g where g.membershipIdCreated != g.founderMembershipId;[/spoiler] Number of groups that were deleted by someone other than the founder or creator: 131[spoiler]select format(count(*), 0) from bungie.groups g where g.deletedByMembershipId != g.founderMembershipId and g.deletedByMembershipId != g.membershipIdCreated;[/spoiler] Number of users whose display name is the same as their unique name: 6,834[spoiler]select format(count(*), 0) from bungie.users u where u.displayName = u.uniqueName;[/spoiler] Number of users whose unique name is a number: 11,604[spoiler]select format(count(*), 0) from bungie.users u where u.uniqueName regexp '[0-9]+';[/spoiler] Top 20 doppelgangers (identical display names): [quote]Camnator - 33 alex - 15 FOX NEWS - 15 lll - 14 SecondClass - 13 NRA Member - 13 Nick - 11 Chris - 9 Matt - 9 Master Chief - 8 Ryan - 7 Jacob - 7 Jake - 7 Ghost - 6 Sam - 6 Ethan - 6 Epsilon Eridani - 6 Tony - 6 Tyler - 6 Le Dustin - 6[/quote][spoiler]select concat( u.displayName, ' - ', count(*) ) from bungie.users u group by u.displayName having count(*) > 1 order by count(*) desc limit 0, 20;[/spoiler] Average number of followers a user has: 3[spoiler]select format(floor(avg(u.followerCount)), 0) from users u;[/spoiler] Top 20 most active days for account creation: [quote]2013-02-18 - 127 2013-02-19 - 108 2013-06-11 - 87 2013-06-13 - 87 2013-06-12 - 80 2013-10-02 - 78 2013-02-20 - 70 2013-06-14 - 69 2013-02-17 - 61 2013-06-17 - 60 2013-02-23 - 60 2013-06-22 - 57 2013-03-14 - 56 2013-07-08 - 56 2013-10-05 - 55 2013-10-06 - 55 2013-02-21 - 54 2013-10-01 - 54 2013-05-26 - 52 2013-05-27 - 50[/quote][spoiler]select concat( date(u.firstAccess), ' - ', format(count(*), 0) ) from bungie.users u group by date(u.firstAccess) order by count(*) desc limit 0, 20;[/spoiler] Top 20 most active days for account updates: [quote]2013-07-03 - 272 2013-07-04 - 205 2013-01-08 - 197 2013-02-18 - 169 2013-10-02 - 143 2013-07-07 - 143 2013-01-25 - 140 2013-02-19 - 134 2013-10-06 - 131 2013-01-11 - 126 2013-02-17 - 126 2013-07-05 - 124 2013-10-05 - 117 2013-10-04 - 105 2013-10-07 - 104 2013-07-06 - 101 2013-07-08 - 101 2013-10-03 - 98 2013-10-01 - 94 2013-06-11 - 90[/quote][spoiler]select concat( date(u.lastUpdate), ' - ', format(count(*), 0) ) from bungie.users u group by date(u.lastUpdate) order by count(*) desc limit 0, 20;[/spoiler] Top 20 most followed users:[quote][url=http://www.bungie.net/en/View/Profile/index?mid=8011]DeeJ[/url] - 2,512 [url=http://www.bungie.net/en/View/Profile/index?mid=3844298]Alpha Lupi[/url] - 1,055 [url=http://www.bungie.net/en/View/Profile/index?mid=6653]Halcylon[/url] - 506 [url=http://www.bungie.net/en/View/Profile/index?mid=282]stoshington[/url] - 494 [url=http://www.bungie.net/en/View/Profile/index?mid=1]Achronos[/url] - 467 [url=http://www.bungie.net/en/View/Profile/index?mid=1189677]Recon Number 54[/url] - 395 [url=http://www.bungie.net/en/View/Profile/index?mid=111662]Hylebos[/url] - 373 [url=http://www.bungie.net/en/View/Profile/index?mid=14130]burritosenior[/url] - 337 [url=http://www.bungie.net/en/View/Profile/index?mid=17925]FoMan123[/url] - 275 [url=http://www.bungie.net/en/View/Profile/index?mid=4878]Spawn[/url] - 266 [url=http://www.bungie.net/en/View/Profile/index?mid=7777]True Underdog[/url] - 258 [url=http://www.bungie.net/en/View/Profile/index?mid=666219]A 3 Legged Goat[/url] - 243 [url=http://www.bungie.net/en/View/Profile/index?mid=3360554]Vien Quitonm[/url] - 242 [url=http://www.bungie.net/en/View/Profile/index?mid=3391609]CamCamm[/url] - 236 [url=http://www.bungie.net/en/View/Profile/index?mid=888158]Destiny Updates[/url] - 202 [url=http://www.bungie.net/en/View/Profile/index?mid=23356]MyNameIsCharlie[/url] - 202 [url=http://www.bungie.net/en/View/Profile/index?mid=1774]Duardo[/url] - 200 [url=http://www.bungie.net/en/View/Profile/index?mid=17956]Cortana Five[/url] - 195 [url=http://www.bungie.net/en/View/Profile/index?mid=744314]Gojira[/url] - 188 [url=http://www.bungie.net/en/View/Profile/index?mid=423038]TopWargamer[/url] - 168[/quote][spoiler]select concat( '[url=http://www.bungie.net/en/View/Profile/index?mid=', u.membershipId, ']', u.displayName, '[/url] - ', format(u.followerCount, 0) ) from users u order by u.followerCount desc limit 0, 20;[/spoiler]