SELECT TOP (30) runid, OptimalVersion, CONVERT(VARCHAR(10),StartTime,23 ) AS StartTime, 
TestName, cast([Total Time E2E] as decimal(10,1)) E2E, UnitsCount, TestsCount 
from [PerformanceResults].[dbo].[BenchmarkTestsSummary] 
where ( OptimalVersion like '7.4.%' and TestEnvironment='QAPerformanceVertica' ) 
order by StartTime DESC

SELECT TestName, cast([Total Time E2E] as decimal(10,1)) AS Baseline
from [PerformanceResults].[dbo].[BenchmarkTestsSummary] 
where ( OptimalVersion = '7.3' and TestEnvironment='QAPerformanceVertica' and TestName = 'Scenario1') 

SELECT runid, OptimalVersion, CONVERT(VARCHAR(10),StartTime,23 ) AS StartTime, TestName, 
cast([Total Time E2E] as decimal(10,1)) E2E,
             (SELECT cast([Total Time E2E] as decimal(10,1)) as Baseline from [PerformanceResults].[dbo].[BenchmarkTestsSummary] AS b
             where ( a.TestName = b.TestName and OptimalVersion = '7.3' and TestEnvironment='QAPerformanceVertica'))
from [PerformanceResults].[dbo].[BenchmarkTestsSummary] AS a
where ( OptimalVersion like '7.4.%' and TestEnvironment='QAPerformanceVertica') 
order by StartTime DESC