SELECT sum(somefield)
  FROM table
  WHERE datefield BETWEEN ? AND ?

##</code><code>##

  SELECT datefield, sum(somefield)
  FROM table
  WHERE datafield BETWEEN ? AND ?
  GROUP BY datefield

##</code><code>##

  DELETE from TABLE WHERE datafield < ?