Cobi

mysql> SELECT `networks`.`name` AS `Network`,COUNT(`channels`.`id`) AS `Channels`,SUM(`channels`.`users`)/COUNT(`channels`.`id`) AS `AUPC` FROM `networks`,`channels` WHERE `channels`.`network` = `networks`.`id` GROUP BY `networks`.`name` ORDER BY `AUPC` DESC;
+--------------------+----------+---------+
| Network            | Channels | AUPC    |
+--------------------+----------+---------+
| NoDramaIRC         |      202 | 40.0396 |
| BlueHell           |       80 | 10.2625 |
| QuakeNet           |    99896 |  7.8350 |
| Cartoon-World      |       13 |  7.5385 |
| PlanetaryGaming    |        4 |  6.7500 |
| IRCwire            |       15 |  6.4667 |
| IrCQ-Net           |     2046 |  6.1789 |
| GlobalGamersCenter |      210 |  6.0524 |
| AlcatrazIRC        |        6 |  5.8333 |
| AfterNET           |      224 |  4.5804 |
| DevHat             |       16 |  4.2500 |
| NothingIRC         |        5 |  4.0000 |
+--------------------+----------+---------+
12 rows in set (1.85 sec)