开发中自己出现的小坑，关于Oracle中group By

一开始 使用MySQL 开发时的查询语句

SELECT
        SR."ID",
        iu.NAME AS name,
        sr.ROOM_CAPACITY AS roomCapacity,
        sr.ROOM_AREA AS roomArea,
        sr.REMARK,
        COUNT(sp.POINT_ID) AS powerPointCount,
        COUNT(rm.ID) AS roomMonitorCount
        FROM
        XZ_SUBSTATION_ROOM sr
        LEFT JOIN XZ_SUBSTATION_POINT sp ON sr.ID = sp.ROOM_ID
        LEFT JOIN XZ_POWER_POINT pp ON sp.POINT_ID = pp.ID
        LEFT JOIN XZ_ROOM_MONITOR rm ON rm.ID = sp.ROOM_ID
        LEFT JOIN XZ_IMPORTANT_USER iu ON iu.ID=sr.USER_ID

在MySQL中运行没有问题，count 可以查询数量

[Err] ORA-00937: not a single-group group function

但是后来选择了Oracle 由于Oracle语法和MySQL不一致，
这条语句使用了count聚合函数，所以在Oracle中必须使用group By，
这时我加上group By 根据 id 分组

SELECT
        SR."ID",
        iu.NAME AS name,
        sr.ROOM_CAPACITY AS roomCapacity,
        sr.ROOM_AREA AS roomArea,