/* skip_forceblocks */ select EnsureType(Avg(CAST(key AS Interval64)), Interval64?) from (select Interval64('P1D') as key); select EnsureType(AvgIf(CAST(key AS Interval64), key > Interval64('P1D')), Interval64?) from (select Interval64('P1D') as key);