Data Base Query sum of marks

See more:

SQL-Server

SQL-Server-2008

Daily exam

Student_id--   Marks --   Date 
  1--	      10  --     30/01/2012
  1           20       25/01/2012
  1           10       20/01/2012
  1           40       11/01/2012
  2	      30       30/01/2012
  2           60       25/01/2012
  2           90       20/01/2012
  2           50       11/01/2012

  1	      20       30/02/2012
  1           20       25/02/2012
  1           10       20/02/2012
  1           40       11/02/2012
  2	      30       30/02/2012
  2           60       25/02/2012
  2           20       20/02/2012
  2           50       11/02/2012

i want out put like

Monthly wice means out put like with parameters of From Date and to date given as inputs

Student_id   Marks    Date 
   1          80       jan 2012
   2          230      jan 2012
   1          90       feb 2012
   2          160      feb 2012

if
Yearly wice means out put like with parameters of From Date and to date given as inputs

Student_id   Marks    Date 
   1          160       2012
   2          390      2012

any one please help me

[edit]Code block added - OriginalGriff[/edit]