> Mysql is planning on making this work:
>
> SELECT id, @a:=COUNT(*), SUM(sum_col)/@a FROM table_name GROUP BY id.
>
> Do we have anything like it (After a discussion with Tom i figure no).
> User variables is nice, especially in these kind of queries.
Well of course they have to make that work - they don't have subselects :P
Chris