title: SQL grouping by month and year
body: <p>I'm not sure what should I write in the following SQL query to show 'date' column like this: "month-year" - "9-2011". </p>
  
  <pre><code>SELECT MONTH(date) + '.' + YEAR(date) AS Mjesec, SUM(marketingExpense) AS SumaMarketing, SUM(revenue) AS SumaZarada 
  FROM [Order]
  WHERE (idCustomer = 1) AND (date BETWEEN '2001-11-3' AND '2011-11-3')
  GROUP BY MONTH(date), YEAR(date)
  </code></pre>
  
  <p>So, what I want to do is to change the data from the first column to show month and year instead of showing month only.</p>