比较复杂的sql统计问题高分

一个表字段统计方式
日期       所说月份   税率    商品税目   合计金额（sum）   合计税额(sum)
-             -        -         -        8160.00          1361.46
2003-04-28    -        -         -        7004.00          1164.94
2010-04-21    -        -         -        1156.00          196.52
2003-04-28    4        -         -        7004.00          1164.94
2010-04-21    4        -         -        1156.00          196.52
2003-04-28    4        0.06      -        234.00           14.04
2003-04-28    4        0.17      -        6770.00          1150.90
2010-04-21    4        0.17      -        1156.00          196.52
2003-04-28    4        0.06      4003     234.00           14.04
2003-04-28    4        0.17      0        50.00            8.50
2003-04-28    4        0.17      0102     6720.00          1142.40
2010-04-21    4        0.17      0102     1156.00          196.524列统计 3列统计  2列统计 1列统计 最后总的统计 看上面的统计结果就能明白统计方式，这个sql如何实现？谢谢