急求：sql实现多列合并

Question

比如说：
 表1：
      姓名      学时      任务时        工作量      
       刘           0              
       刘                          5
       刘                                               7
       李           4             
      李                          0
       李                                               10
 
最后变成表2：
       姓名      学时      任务时      工作量
         刘         0              5                 7
         李         4              0                 10
 
是不是要用group by啊？
 具体怎么实现呢？
 由于刚学vb，还请多多帮助啊

Answer 1

sql="select 姓名,sum(学时),sum(任务时)，sum(工作量) from 表1 group by 姓名"