SELECT
   Sum(Earning) AS Amount,
   MONTH(DateCreated) AS Month
FROM
   TheTable
WHERE
   DateCreated
BETWEEN
   @DateFrom AND @DateTo
GROUP BY **???**