我想求出按类型的总消费额 sql 语句怎么写啊？？？
tableL:
leixing            jin 'e     riqi
烟                  8         2008-2-8
酒                  23        2008-2-9
烟                  16        2008-2-10
酒                  32        2008-2-11

我要求出的结果是
烟      24
酒      55

请高手抽出时间指点~！！！谢谢~！！！

select leixing ,sum(isnull(jin'e,0)) from tablel gorup by leixing