我将直接按年份和月份进行聚合，作为单个文本字段：

SELECT
    CONVERT(varchar(7), <column>, 120) AS Year-Month,
    COUNT(*) AS Total_Request
FROM <table>
GROUP BY
    CONVERT(varchar(7), <column>, 120);

如果您真的想要年份和月份的三个字母缩写，您可以尝试：

SELECT
    YEAR(<column>) AS Year,
    LEFT(DATENAME(MONTH, <column>), 3) AS Month,
    COUNT(*) AS Total_Request
FROM <table>
GROUP BY
    YEAR(<column>),
    LEFT(DATENAME(MONTH, <column>), 3);

在sql server 2012中，您可以使用format函数

SELECT 
     FORMAT( YourColumn, 'yyyy-MMMM')
     ,COUNT(*) AS Total_Request
FROM 
    <table>
GROUP BY 
    FORMAT( YourColumn, 'yyyy-MMMM')

也可以添加区域性作为第三个参数。在sql语法下面：

FORMAT ( value, format [, culture ] )

有关文档，请参阅此处