请教两个表的联合查询如何写sql语句？

Question

表A
ID      value1
2          1       
5          2
2          4 
6           1表B
ID         fee
2            50
5            30
1            80     要求：a表里面的value1根据ID求和，sum（value1） group by ID  ， 然后从B表按照ID查询出fee
请问这个sql怎么写啊？查询结果如下：
ID      sum（value1 ）       fee
2         5                                 80
5         2                                30
6          1                               null
   

Answer 1

  
select a.*,B.fee from (select id,sum(value1) from a group by value1)a left join B on a.id=B.id

Answer 2

查询结果应该是：查询结果如下：
ID      sum（value1 ）       fee
2         5                                 50
5         2                                30
6          1                               null

Answer 3

select id,sum(value1),
(select fee from b where id=a.id)
from a
group by id