请高手指教!

现有表ABC，数据如下：

DATA                 NAME              SIZE                                QUANTITY       IN         OUT         SITUATION

2005-10-1     409L/NO.1     (0.50mm)0.44x1234xM            10              20         30             40

2005-10-1     201/2B            (0.50mm)0.34x1234xM            30              10         20             10

2005-10-3     409L/NO.1    (3.0mm)0.44x1234xM              20              15         13                20

2005-10-5     201/2B           (3.0mm)0.34x1234xM              13              20         32               40

现在要求结果如下：

2005-10-1     409L/NO.1     (0.50mm)0.44x1234xM            10              20         30             40

2005-10-1     201/2B           (0.50mm)0.34x1234xM            30              10         20             10

2005-10-3     409L/NO.1    (3.0mm)0.44x1234xM              20              15         13                20

2005-10-5     201/2B           (3.0mm)0.34x1234xM              13              20         32               40

                                                               (0.44)小计：                 30             45         43               60

                                                               (0.34)小计：                43              30          52                50

                                                    (0.5mm)小计：                       40             30          50               50

                                                    (3.0mm)小计：                       43              35         45               60

                        (201/2B)小计：                                                   43               30          52             50

                         (409L/NO.1)小计：                                            30                35         43             60

月份合计：                                                                                   73                 65         95            110

用SQL语句怎样实现上面结果！！！