MariaDB [teeworlds]> select Map, avg(TeamSize) from (select record_maps.Map as Map, count(Name) as TeamSize from record_teamrace inner join record_maps on record_teamrace.Map = record_maps.Map where record_maps.Server = "DDmaX" group by ID) as l group by Map having avg(TeamSize) > 2 order by avg(TeamSize) desc; +---------------------+---------------+ | Map | avg(TeamSize) | +---------------------+---------------+ | NUT_short_race4 | 7.9648 | | NUT_hardcore_bestof | 4.1607 | | NUT Hardcore UNITED | 4.1400 | | NUT_race4 | 4.0405 | | skynet compilation | 3.9000 | | Scabrous 2 | 3.6842 | | NUT_hardcore_race4 | 3.6154 | | NUT_race1 | 3.5586 | | Inspire | 3.5172 | | NUT_hardcore_race1 | 3.4737 | | Picklock | 3.3889 | | NUT_hardcore_race2 | 3.3784 | | slow | 3.3740 | | Nightmare | 3.3103 | | At Night | 3.2600 | | lemonland | 3.1951 | | NUT_race8 | 3.1864 | | Frats 5 | 3.1778 | | DawnOfDust | 3.1273 | | 3way | 3.1250 | | Steff I beginning | 3.0619 | | Forever | 3.0517 | | NUT_hardcore_race5 | 3.0488 | | NUT_short_race6 | 3.0305 | | DeathClaw | 3.0000 | | Curse | 2.9836 | | NUT_hardcore_race6 | 2.9091 | | Cocaine | 2.8846 | | Rampage | 2.8750 | | Ice | 2.8478 | | Adrenaline 3 | 2.8286 | | #MegaRosenkohl | 2.8065 | | Dreadful | 2.8049 | | Imagination3 | 2.7917 | | Around the Globe | 2.7917 | | Beachmap | 2.7727 | | Frats 2 | 2.7681 | | MicCore | 2.7561 | | NUT_race7 | 2.7444 | | SpongeBob 2 | 2.7358 | | DayWalker | 2.7119 | | Lost Story | 2.6932 | | HardcoreZ | 2.6667 | | Dels 3 | 2.6531 | | Deadline 1 | 2.6429 | | Green | 2.6351 | | Space | 2.6327 | | SkyIsland | 2.6222 | | Executive | 2.6032 | | Steff III peace | 2.5963 | | Regret | 2.5900 | | TheWalkingDead | 2.5484 | | Red Hell | 2.5357 | | Eclipse | 2.5250 | | Multivitamin | 2.5000 | | LowPossibility3.1 | 2.4889 | | NUT_race3 | 2.4790 | | NUT_hardcore_race3 | 2.4690 | | skynet10 | 2.4627 | | GlassBox 9 | 2.4622 | | HappyEaster | 2.4554 | | Therapy | 2.4545 | | Full Moon | 2.4483 | | Myth | 2.4426 | | CrazyHOOD | 2.4375 | | World of Magic | 2.4375 | | Madness 5 | 2.4328 | | HearTbeaT | 2.4286 | | HellGate 2.5 | 2.4224 | | Veni Vidi Vici | 2.3978 | | NUT_race2 | 2.3908 | | Volcano | 2.3906 | | Fantabob | 2.3867 | | Outlet | 2.3846 | | SpongeBob 1 | 2.3842 | | Summer Hell | 2.3830 | | Jajka | 2.3800 | | Hard Way 1.0 | 2.3750 | | Black_City | 2.3738 | | ~AuTuMn~ | 2.3676 | | Best Of | 2.3585 | | valentees | 2.3562 | | Chaos 4 | 2.3542 | | black-mountains 2 | 2.3500 | | HellGate 1 | 2.3431 | | VeryLow1 | 2.3409 | | Retro 0 | 2.3373 | | HellGate 5 | 2.3357 | | NUT_race6 | 2.3272 | | HearTcross | 2.3267 | | Insane 2 | 2.3261 | | Maroon | 2.3237 | | supernice | 2.3226 | | Gold Rush | 2.3200 | | IronFlight | 2.3158 | | HellGate 1.5 | 2.3154 | | Fairy Land | 2.3132 | | Dels 2 | 2.3115 | | Maximum | 2.3107 | | R.I.P | 2.3107 | | Lime | 2.3053 | | VeryLow2 | 2.3043 | | HellGate 3 | 2.3000 | | NUT_race9 | 2.2931 | | whatever | 2.2899 | | Besbex | 2.2874 | | Energie | 2.2857 | | Dead Island | 2.2832 | | Totoro | 2.2775 | | Night Jungle | 2.2774 | | Tylost | 2.2745 | | Fly-4-2 | 2.2742 | | o_O | 2.2734 | | Deadline 2 | 2.2708 | | Zip | 2.2653 | | Pandora | 2.2573 | | HellGate 4 | 2.2560 | | Creative | 2.2522 | | Violet | 2.2449 | | Blizzard! | 2.2429 | | Natura | 2.2391 | | Insane 3 | 2.2381 | | Dels | 2.2372 | | Explosive | 2.2353 | | NightRunner | 2.2284 | | Confusion | 2.2247 | | R2D2 | 2.2243 | | GTF 1 | 2.2190 | | Four Gates | 2.2167 | | Stamina | 2.2158 | | Think! 2 | 2.2128 | | Slim | 2.2123 | | skynet8 | 2.2056 | | Angry 2 | 2.2041 | | skynet9 | 2.2026 | | Frats 1 | 2.2016 | | Halloween | 2.1967 | | Alpaga | 2.1939 | | Black & Red | 2.1932 | | Skyisland3 | 2.1930 | | DARKness 1 | 2.1919 | | Tylost 2 | 2.1912 | | KitKat 2 | 2.1880 | | Next | 2.1863 | | Michler 2 | 2.1852 | | GreenDream | 2.1844 | | Tribute 2 | 2.1824 | | StormzZ | 2.1824 | | Get The Gifts | 2.1791 | | black-mountains | 2.1786 | | Insane | 2.1786 | | GlassBox 10 | 2.1773 | | Retro 1 | 2.1752 | | Equalize! | 2.1747 | | Zephronikon | 2.1746 | | Ntumba | 2.1702 | | Revolution | 2.1699 | | Chaos 3 | 2.1698 | | illusion | 2.1685 | | Bumba | 2.1677 | | Autumn | 2.1673 | | Feeling | 2.1667 | | Impulse_03 | 2.1667 | | Paranoia | 2.1667 | | Hope 2 | 2.1643 | | NUT_race5 | 2.1642 | | Back to the Roots 2 | 2.1627 | | The Captive Mind | 2.1622 | | Angry | 2.1618 | | lovely me | 2.1606 | | Tribute 1 | 2.1592 | | skynet3 | 2.1584 | | KitKat 1 | 2.1579 | | Dream 1 V2 | 2.1566 | | Arcade 2 | 2.1559 | | run_the_cube | 2.1538 | | Diamond | 2.1527 | | BrokenBlack-1 | 2.1519 | | Evo 1 | 2.1515 | | Blue Hell | 2.1509 | | HappyValenTees | 2.1509 | | Drunk | 2.1507 | | Divinum V2 | 2.1507 | | FWYS 4 | 2.1500 | | pepsi | 2.1491 | | skynet6 | 2.1486 | | Cloud Nine | 2.1477 | | Frats 4 | 2.1475 | | S-Race 2 | 2.1464 | | Difficult 1.2 | 2.1449 | | HellGate 2 | 2.1447 | | Rockita | 2.1442 | | Brownie | 2.1435 | | Difficult 2.3 | 2.1429 | | Nasa | 2.1421 | | blue-mountains | 2.1417 | | Chaos 2 | 2.1412 | | TsinmaS | 2.1393 | | Hook Fever | 2.1354 | | smile | 2.1342 | | lovely me2 | 2.1341 | | Finito | 2.1337 | | Creepeez | 2.1322 | | Difficult 1.3 | 2.1321 | | Caveman | 2.1317 | | 4luvz | 2.1314 | | Frats 3 | 2.1304 | | Elo-Hell | 2.1296 | | CreeperFace | 2.1280 | | Frostbite | 2.1280 | | Strike | 2.1279 | | Bercy | 2.1274 | | FWYS 1 | 2.1262 | | JetPack | 2.1230 | | Google | 2.1194 | | skynet5 | 2.1175 | | Snowy Sakura I | 2.1168 | | 007 - 2 | 2.1166 | | Experiment | 2.1165 | | Cigarette | 2.1152 | | Back to the Roots 1 | 2.1150 | | LATOM | 2.1132 | | Pathway 4 | 2.1132 | | Hell 1 V2 | 2.1115 | | Chaos Factory 2 | 2.1111 | | Lost Castle | 2.1111 | | CCrush | 2.1091 | | skynet2 | 2.1090 | | .Background' | 2.1075 | | Dark Rainbow | 2.1063 | | Paik | 2.1059 | | Equestria Girls | 2.1052 | | AreaOfEffect | 2.1037 | | Arcade | 2.1027 | | Grey 1 | 2.1025 | | Jungle | 2.1023 | | Deria | 2.1019 | | HeyYa | 2.1000 | | Away | 2.0993 | | BoX | 2.0991 | | Difficult 1.1 | 2.0986 | | vitaminC | 2.0984 | | Dragonscale | 2.0982 | | Core | 2.0981 | | BSWL | 2.0977 | | WinterMine | 2.0969 | | Desolation | 2.0964 | | Drag-House | 2.0954 | | Hope | 2.0930 | | Underworld | 2.0923 | | FreeZe | 2.0915 | | Next 2 | 2.0909 | | Peaks | 2.0902 | | skynet1 | 2.0901 | | ATLAS | 2.0899 | | Michler | 2.0893 | | Drain-Age | 2.0886 | | Grey 2 | 2.0877 | | Pandaland | 2.0871 | | Moon of the Jungle | 2.0870 | | Fly to the Moon | 2.0854 | | Difficult 2.2 | 2.0851 | | skynet7 | 2.0849 | | Rovo | 2.0846 | | Heroic | 2.0838 | | Derpy 1 | 2.0828 | | Pathway | 2.0820 | | -Ikarus- | 2.0811 | | Pathway 3 | 2.0809 | | Woader | 2.0796 | | 0 KBeeeR S - 2 | 2.0789 | | Fall In Love | 2.0788 | | Skyfly | 2.0787 | | Rainboom | 2.0779 | | Winter Dream | 2.0762 | | Love 0.6 | 2.0757 | | Black Jungle | 2.0755 | | Reach Pluto | 2.0749 | | Want_a_Cookie | 2.0740 | | SilentNight | 2.0732 | | Grey 3 | 2.0726 | | Deeve1 | 2.0722 | | Skyisland2 | 2.0719 | | Blue & Yellow | 2.0716 | | Standby | 2.0714 | | Xeno Race #1 | 2.0703 | | secreT | 2.0698 | | Genesis | 2.0692 | | Grey 4 | 2.0688 | | S-Race 1 | 2.0688 | | RockBlock 1 | 2.0686 | | Cloudy | 2.0684 | | brainbase | 2.0682 | | Axom | 2.0675 | | Colors V2 | 2.0668 | | Brick World 2 | 2.0638 | | Drag-House2 | 2.0630 | | Forest | 2.0619 | | Yin&Yang | 2.0608 | | Dream 2 | 2.0607 | | EasyCore | 2.0607 | | Genesis-2 | 2.0601 | | Everest | 2.0594 | | MCPV | 2.0590 | | Reality | 2.0588 | | DARKness 2 | 2.0581 | | Shaxx | 2.0578 | | double up | 2.0575 | | FWYS 5 | 2.0563 | | Black | 2.0562 | | RageOne | 2.0560 | | Chaos Factory | 2.0557 | | Blue Sky | 2.0549 | | Red & Orange | 2.0544 | | 21 | 2.0538 | | JustMap | 2.0533 | | DeadEnd | 2.0529 | | Brick World | 2.0519 | | 0 KBeeeR S - 1 | 2.0518 | | skynet4 | 2.0516 | | Icy Mountain | 2.0507 | | FWYS 3 | 2.0503 | | DoT | 2.0498 | | Blue Adventures 1 | 2.0479 | | DaMap | 2.0474 | | Icy Morning | 2.0473 | | Toxic | 2.0468 | | Bixnet | 2.0466 | | Desert Pain | 2.0457 | | Purple Panic 2 | 2.0447 | | NUT_short_race1 | 2.0443 | | X-Cross | 2.0415 | | FWYS 2 | 2.0414 | | TheVoiD | 2.0406 | | 42 | 2.0403 | | Sky line | 2.0399 | | Spectrus I | 2.0392 | | BlueRift | 2.0390 | | Hop | 2.0383 | | DaMap 2 | 2.0377 | | Pathway 2 | 2.0376 | | Snowzz | 2.0374 | | 2Long | 2.0370 | | Pale 2 | 2.0341 | | mario(=D) | 2.0335 | | DaFuQ | 2.0335 | | Castle of Glass | 2.0329 | | The Tower | 2.0325 | | JLI 1 | 2.0315 | | Difficult 2.1 | 2.0315 | | Divided | 2.0307 | | Pale | 2.0307 | | Purple Panic | 2.0298 | | Chaos 1 | 2.0294 | | Poke | 2.0286 | | Sunsetcave | 2.0286 | | Impulse_01 | 2.0284 | | Impulse_02 | 2.0265 | | Ambrosia | 2.0255 | | Notice 1 | 2.0250 | | 007 - 1 | 2.0247 | | 84 | 2.0189 | | NUT_short_race7 | 2.0087 | +---------------------+---------------+ 363 rows in set (2.385 sec)