CompGroupSQLQuery.sql

SELECT TOP 1
		PhysicianName,
		wrvuactualytd AS WRVU_Actual,
		wrvuthresholdYTD AS WRVU_Threshold,
		[Rate per Work RVU] AS RatePerRVU,
		EarnedCompYTD AS EarnedComp,
		clinicalbasedrawYTD AS BaseDraw,
		QualityCompWithholdYTD AS QualityBonusWithold,
		ExcessEarnedCompYTD AS ExcessEarnedComp,
		TrueupQ1,
		TrueupQ2,
		TrueupQ3,
		TrueupQ4,
		TrueupYTD,
		EstCompDueYTD,
		GroupWRVUsYTD,
		GroupThresholdYTD,
		GroupWeightedAVGRate,
		GroupEarnedCompYTD,
		GroupBaseDrawYTD,
		GroupQualityCompwithholdYTD,
		GroupExcessEarnedCompYTD,
		GroupTrueupQ1,
		GroupTrueupQ2,
		GroupTrueupQ3,
		GroupTrueupQ4,
		GroupTrueupYTD,
		GroupEstimatedEarnedCompDueYTD,
		StartDate,
		ReportPeriod,
		ROW_NUMBER() OVER (PARTITION BY PhysicianName ORDER BY ReportPeriod ASC) AS TotalReportPeriods
		FROM PhysicianComp_Display
  WHERE Year = '2016' AND SpecialtyGroup = 'MED HOSPITALIST, IFH'
  ORDER BY TotalReportPeriods DESC