这个SQL语句可怎么写？

[pcbaby]

表A
ID，username

表B
ID，username,click(整型，每条记录的数字都不一样)

现要统计每个username的click总共是多少，并按click从大到小排行，就是说要把click的数字按照每个用户名算出总数，再按这个总数排序，如何写？

[qfacy]

select sum(click) as ff,username from table group by username order by ff

[enjsky]

select sum(click) as click_num from tab_b group by username order by click_num desc

[erplab]

select distinct sum(click) as click_num from tab_b group by username order by click_num desc

[myvicy]

来晚了。

[yesyesyes]

select username,sum(click) as click_num from tab_b group by username order by click_num desc

[jingxiaoping]

楼上两个写的没啥区别吧。