Total sales per month

Question

If you have a table with SALES {Customer_ID, Price, SmallDateTime date}. How do you report all sales per month?

SELECT Sum(Price) As Total Sales FROM SALES Group By What Having What 

Answer 1

  SELECT YEAR(date) as SalesYear,
         MONTH(date) as SalesMonth,
         SUM(Price) AS TotalSales
    FROM Sales
GROUP BY YEAR(date), MONTH(date)
ORDER BY YEAR(date), MONTH(date)

Answer 2

SELECT CONVERT(CHAR(7), SmallDateTime, 120) as Year_Month,
       SUM(Price)
    FROM Sales
    GROUP BY CONVERT(CHAR(7), SmallDateTime, 120) 
    ORDER BY Year_Month