Cacher is the code snippet organizer for pro developers

DECLARE @centerId INT = 1

SELECT u.UserId EngUserId
	,u.UserName EngName
	,u.Email EngEmail
	,u.Region
	,u.FacilityDesc
	,u.SecondaryRole
	,u.ManagerName
	,u.ManagerName2
	,u.ManagerName3
	,s.SkillName
	,p.NAME AS PGUName
	,w.NAME AS Wave
	,asm.NAME AS AssessmentStatus
FROM dbo.[User] u
INNER JOIN dbo.UserXCenter uc ON u.UserId = uc.UserId
	AND uc.CenterId = @centerId
LEFT JOIN dbo.UserCenterXCenterPguSkill uccps ON uc.UserXCenterId = uccps.UserXCenterId
	AND uccps.IsActive = 1
LEFT JOIN dbo.CenterXPGUXSkill cps ON uccps.CenterXPGUXSkillId = cps.CenterXPGUXSkillId
LEFT JOIN dbo.CenterXPGU cp ON cps.CenterXPGUId = cp.CenterXPGUId
LEFT JOIN dbo.PGU p ON cp.PGUId = p.PGUId
LEFT JOIN dbo.Skill s ON cps.SkillId = s.SkillId
LEFT JOIN dbo.Assessment a ON uccps.Id = a.UserCenterXCenterPguSkillId
	AND a.IsActive = 1
	AND a.WaveId IN (
		77
		,69
		,68
		,66
		,65
		,60
		,59
		)
LEFT JOIN dbo.Wave w ON a.WaveId = w.Id
LEFT JOIN dbo.AssessmentStatusMaster asm ON a.AssessmentStatusId = asm.Id
WHERE u.IsActive = 1 AND u.FacilityDesc = 'CSC BGL'
GROUP BY u.UserId
	,u.UserName
	,u.Email
	,u.FacilityDesc
	,u.Region
	,u.SecondaryRole
	,u.ManagerName
	,u.ManagerName2
	,u.ManagerName3
	,s.SkillName
	,p.NAME
	,w.NAME
	,asm.NAME
ORDER BY u.UserId
	,u.UserName
	,u.SecondaryRole