SELECT toStartOfDaytoDateTimeDs AS datetime_day_Ds AppIdentifier AS AppIdentifier -- sumAvgDeviceTime AS index_avgdevicetime_0 CASE WHEN countAvgDeviceTime!=0 1 THEN countAvgDeviceTime!=0 --

The SQL query you provided is encountering an error. The error message states that there is no common supertype for types Float64 and UInt64 because some of them are integers and some are floating point, but there is no floating point type that can exactly represent all the required integers.

To resolve this issue, you need to ensure that the types used in the query are compatible. You may need to convert the data types appropriately or check if there are any inconsistencies in the data.