/****** Script for SelectTopNRows command from SSMS  ******/
SELECT CONVERT(VARCHAR(10), [DateTime], 104) AS [Day]
      ,AVG(CAST([Cores] AS FLOAT)) AS Cores
      ,AVG(CAST([FreeCores] AS FLOAT)) AS FreeCores
      ,AVG([CpuUtilization]) AS CpuUtilization
      ,AVG(CAST([Memory] AS FLOAT)) AS Memory
      ,AVG(CAST([FreeMemory] AS FLOAT)) AS FreeMemory
      ,MAX([ExecutionTimeHours]) AS [ExecutionTimeHours]
      ,MAX([ExecutionTimeFinished]) AS [ExecutionTimeFinished]
      ,MAX([StartToEndTimeFinished]) AS [StartToEndTimeFinished]
  FROM [HeuristicLab.Hive-3.4].[dbo].[view_Statistics]
  GROUP BY CONVERT(VARCHAR(10), [DateTime], 104)
  ORDER BY CONVERT(VARCHAR(10), [DateTime], 104) DESC