合并 iOS 和 Android 客户端数量统计 - SQL 子查询示例

可以使用子查询将两个查询结果合并为一个变量 category。以下是一个示例查询：\n\n\nSELECT iOS_Client, Android_Client, iOS_Client + Android_Client AS category\nFROM (\n SELECT COUNT(DISTINCT AppIdentifier) AS iOS_Client\n FROM log_iMonkey_iOS_overview\n) AS ios,\n(\n SELECT COUNT(DISTINCT AppIdentifier) AS Android_Client\n FROM log_iMonkey_Android_overview\n) AS android\n