问一条sql

Question

一个表User，有字段id，name，message，现在要查出这个表中发消息（message）最多的人的名字，
怎么表达啊？谢谢

Answer 1

select n form (select name n count(id) c from user group by id order by c desc limit 1) as a;