SQL的简单统计问题？

[zyl2001]

字段：busno,classtime,interticket,outerticket,mannum.
我想实现：
=====班次(classtime)=====
车号(busno) 人数(sum(mannum)) 收入(sum(interticket+outerticket))

车号(busno) 人数(sum(mannum)) 收入(sum(interticket+outerticket))

车号(busno) 人数(sum(mannum)) 收入(sum(interticket+outerticket))

....

如何写这个语句？

[viiqii]

select classtime as 班次,
busno as 车号,
sum(mannum) as 人数,
sum(interticket+outerticket) as 收入
from tablename
group by classtime

[愉快的登山者]

select classtime 班次, busno 车号, sum(mannum) 人数, sum(interticket+outerticket) 收入 from talbe1
group by classtime, busno

[welyngj]

看不懂？

[antoversky]

select busno 车号,sum(mannum) 人数,(sum(interticket+outerticket)) 收入
from table group by classtime,busno

[txlicenhe]

select classtime as 班次, busno as 车号, sum(mannum) as 人数, sum(interticket+outerticket) as 收入 from 表
group by classtime, busno

[pengdali]

select classtime 班次,busno 车号,sum(mannum) 人数,sum(interticket+outerticket) 收入 from 表 group by classtime,busno

[aierong]

select busno as 车号,
sum(mannum) as 人数,
sum(interticket+outerticket) as 收入
from tablename
group by busno



按busno 分组