＃1242-子查询返回多于1行

我得到一个错误:＃1242 - 当我运行了此SQL子查询返回多于1行

CREATE VIEW TEST AS

SELECT CC_Name, COUNT(*) as Total_Beds,

(SELECT COUNT(*) FROM Bed WHERE ResPatient_ID > 0 GROUP BY CC_Name) as Occupied_Beds,

(SELECT COUNT(*) FROM Bed WHERE ResPatient_ID IS NULL GROUP BY CC_Name) as Free_Beds

FROM Bed

GROUP BY CC_Name;