• seems simple enough, your dates should be in the WHERE clause, not GROUP BY clause, like this:

    SELECT sName, SUM(sinterventions) AS sinterventions, SUM(sareas) AS sareas

    FROM mytable

    WHERE DateValue BETWEEN '2012-12-20' AND '2012-12-23'

    GROUP BY sName