SELECT category COUNTDISTINCT AppIdentifier AS countFROM SELECT AppIdentifier CASE WHEN AppIdentifier LIKE comtencentqyxin OR AppIdentifier LIKE comtencentvphoenixdb OR AppIden

您可以使用以下查询来整合两个'WXG'并将它们的数值相加：

SELECT category, SUM(count) AS count FROM ( SELECT category, count FROM ( SELECT category, COUNT(DISTINCT AppIdentifier) AS count FROM ( SELECT AppIdentifier, CASE WHEN AppIdentifier LIKE 'com.tencent.qy.xin%' OR AppIdentifier LIKE 'com.tencent.vphoenix.db%' OR AppIdentifier LIKE 'com.tencent.xin%' THEN 'WXG' WHEN AppIdentifier LIKE 'com.tencent.meeting.dev%' OR AppIdentifier LIKE 'com.tencent.fx.rtmpdemo2%' OR AppIdentifier LIKE 'com.tencent.tx.image.demo%' OR AppIdentifier LIKE 'com.tencent.TTNews.db%' OR AppIdentifier LIKE 'com.tencent.sosomap.dailybuild%' OR AppIdentifier LIKE 'com.tx.image.demo%' OR AppIdentifier LIKE 'com.tencent.meeting.dev.qapm%' OR AppIdentifier LIKE 'com.tencent.meeting%' THEN 'CSIG' WHEN AppIdentifier LIKE 'com.tencent.QQMusic.dailybuild%' OR AppIdentifier LIKE 'com.tencent.QQKSong.rdmpush%' OR AppIdentifier LIKE 'com.tencent.QQKSong%' THEN 'TME' WHEN AppIdentifier LIKE 'com.cctv.yangshipin.app.iphone%' OR AppIdentifier LIKE 'com.tencent.ccg.virtualhuman.beta.db%' OR AppIdentifier LIKE 'com.tencent.sportskbs%' OR AppIdentifier LIKE 'com.tencent.qqlivei18n%' OR AppIdentifier LIKE 'com.tencent.live4iphone%' OR AppIdentifier LIKE 'com.tencent.ehe.db%' OR AppIdentifier LIKE 'com.tencent.tencentXVideo%' OR AppIdentifier LIKE 'com.tencent.ccg.virtualhuman.db%' THEN 'PCG' END AS category FROM log_iMonkey_iOS_overview ) AS t GROUP BY category UNION ALL SELECT 'WXG' AS category, COUNT(DISTINCT PlatformType) as count FROM log_iMonkey_Wechat_overview ) AS t ) AS t GROUP BY categor