SELECT AppIdentifier AS AppIdentifier sumTotalDeviceTime AS index_totaldevicetime_0 sumTotalDevicesCount AS index_totaldevicescount_0 maxCrashCount AS index_crashcount_0 maxCoverageCount AS index_

SELECT AppIdentifier AS AppIdentifier, sum(TotalDeviceTime) AS index_totaldevicetime_0, sum(TotalDevicesCount) AS index_totaldevicescount_0, max(CrashCount) AS index_crashcount_0, max(CoverageCount) AS index_coveragecount_0, CASE WHEN sum(TotalDeviceTime) = avg(AvgDeviceTime) THEN sum(AvgDeviceTime) / count(*) ELSE avg(AvgDeviceTime) END AS index_avgdevicetime_0 FROM log_iMonkey_iOS_overview WHERE ( TotalDeviceTime NOT IN (-1) OR TotalDeviceTime IS NULL ) AND ( Ds >= toDateTime(#comprehensive_time.start#) AND Ds <= toDateTime(#comprehensive_time.end#) ) GROUP BY AppIdentifier ORDER BY AppIdentifier DES