The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
with cte as ( select -1 as kli_kliniknr, max(m.MeasurementDate) as MeasurementDate, SUM(NumberOfMeasurements) as NumberOfMeasurements, SUM(NumberOfMen) as NumberOfMen, SUM(NumberOfWomen) as NumberOfWomen, -- What is the difference between these two rows? avg( Q1 * NumberOfMeasurements / NumberOfMeasurements) as Q1, sum( Q1 * NumberOfMeasurements) / sum(NumberOfMeasurements) as Q1x, from [BPSD].[dbo].[MeasurementStatisticsPerUnit] m group by m.MeasurementDate ) select * from cte ;
Join the community of 500,000 technology professionals and ask your questions.