想在MYSQL中进行查询包含BTIT的部门和非BTIT的部门

部门字段包含多个值，其中有BTIT的，和其他非BTIT的，非BTIT的我想在结果中展示为others

如图：将BTIT之外的所有部门数据求和并将OrgName字段改为others
请问可以实现吗？如何实现？

SELECT
OrgName,
sum( VM_Count ) AS VM_Count,
sum( TotalCost ) AS TotalCost
FROM
table
WHERE
OrgName = 'BTIT' UNION
SELECT
'others',
sum( VM_Count ) AS VM_Count,
sum( TotalCost ) AS TotalCost
FROM
table
WHERE
OrgName <> 'BTIT';
供参考

SELECT (CASE c.L3_OrgName  when 'BTIT' then 'BTIT' else '其他' end)  as OrgName,count(0) as VM_Count,sum(s.totalCost) as TotalCost FROM
sc_server as s,
cmdb_user_info as c
where c.name = s.applicant GROUP BY OrgName

用case when就可以实现，这只是大概思路，结果的正确性还需要你进行调试