查询报错求解

[qq_39229809]

select * from (
select SUM(money)as MONEY,month(createdate),year(createdate) from tb_payrecord

group by month(createdate),year(createdate)
)

很简单的语句不知道为什么会报错。

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('tb_payrecord') IS NOT NULL DROP TABLE tb_payrecord
GO
CREATE TABLE tb_payrecord(
	createdate DATETIME,
	[money] INT
)
GO
SET NOCOUNT ON
INSERT INTO tb_payrecord(createdate,[money]) VALUES('2018-10-01',20);
INSERT INTO tb_payrecord(createdate,[money]) VALUES('2018-10-02',30);
INSERT INTO tb_payrecord(createdate,[money]) VALUES('2018-11-05',40);
INSERT INTO tb_payrecord(createdate,[money]) VALUES('2018-11-06',50);
GO
----- 以上为测试数据 ----

SELECT *
FROM   (
           SELECT SUM(MONEY)         AS MONEY,
                  MONTH(createdate)  AS m,      --必须指定别名
                  YEAR(createdate)   AS y       --必须指定别名
           FROM   tb_payrecord
           GROUP BY
                  MONTH(createdate),
                  YEAR(createdate)
       ) AS t    --必须指定别名

[二月十六]

SELECT
    *
FROM
    (
        SELECT
            SUM(money) AS MONEY,
            MONTH(createdate) 别名1,
            YEAR(createdate) 别名2
        FROM
            tb_payrecord
        GROUP BY
            MONTH(createdate),
            YEAR(createdate)
    ) t;