求SQL神帮忙解决问题，谢谢

Question

表test
id store

1 33

2 55

3 66

4 88

5 12

查询或的结果
id store store1 store2
1 33 33 33
2 55 88 121
3 66 154 275
4 88 242 517
5 12 254 771

求SQL语句

Answer 1

 select id,store,store1,(select SUM(store1) from (select id,store,(select SUM(store) from t_test b where b.ID<=a.ID ) store1 from t_test a) copyt where copyt.ID<=thist.ID) store2 from (select id,store,(select SUM(store) from t_test b where b.ID<=a.ID ) store1 from t_test a) thist