如何新增数据表log_android_crash并查询log_iOS_crash和log_android_crash数据

要新增数据表log_android_crash，可以使用以下语句：

CREATE TABLE log_android_crash ( crash_uuid VARCHAR, -- 其他列 );

要在log_android_crash和log_iOS_crash两个表中进行查询，并在不满足log_iOS_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier时转到log_android_crash查询，可以使用以下语句：

SELECT CASE WHEN log_iOS_crash.crash_uuid IS NOT NULL THEN log_iOS_crash.crash_uuid ELSE log_android_crash.crash_uuid END AS crash_uuid, COUNT(CASE WHEN log_iOS_crash.crash_uuid IS NOT NULL THEN log_iOS_crash.crash_uuid ELSE log_android_crash.crash_uuid END) AS count, CASE WHEN log_iOS_crash.crash_uuid IS NOT NULL THEN log_iMonkey_Wechat_overview.PlatformType ELSE '' -- 如果在log_android_crash查询到数据，则将PlatformType设为空字符串 END AS PlatformType FROM log_iOS_crash FULL OUTER JOIN log_iMonkey_Wechat_overview ON log_iOS_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier FULL OUTER JOIN log_android_crash ON log_android_crash.crash_uuid = log_iMonkey_Wechat_overview.CrashIdentifier WHERE ( log_iOS_crash.crash_uuid IS NOT NULL OR log_android_crash.crash_uuid IS NOT NULL ) AND ( log_iOS_crash.crash_uuid GLOBAL IN ( SELECT DISTINCT CrashIdentifier FROM log_iMonkey_Wechat_overview WHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND Ds >= toDateTime(#wechat_crash_level_time.start#) AND Ds <= toDateTime(#wechat_crash_level_time.end#) GROUP BY PlatformType, CrashIdentifier ) OR log_android_crash.crash_uuid GLOBAL IN ( SELECT DISTINCT CrashIdentifier FROM log_iMonkey_Wechat_overview WHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND Ds >= toDateTime(#wechat_crash_level_time.start#) AND Ds <= toDateTime(#wechat_crash_level_time.end#) GROUP BY PlatformType, CrashIdentifier ) ) GROUP BY crash_uuid, PlatformType