Cacher is the code snippet organizer for pro developers

SELECT p.NAME AS PGU
	,s.SkillName
	,dbo.UFN_GetATPNameByATPId(ATP.ActivityXTypeXPortfolioId) AS ATP
	,QC.NAME AS Complexity
	,COUNT(QM.QuestionId) AS AvailableQuestionCount
FROM QuestionMaster QM WITH (NOLOCK)
INNER JOIN QuestionXActivity QA ON QM.QuestionId = QA.QuestionId
	AND QA.IsActive = 1
INNER JOIN ActivityXTypeXPortfolio ATP ON QA.ActvityId = ATP.ActivityXTypeXPortfolioId
	AND ATP.IsActive = 1
INNER JOIN Activity A ON ATP.ActivityId = A.ActivityId
	AND a.IsActive = 1
INNER JOIN PortfolioMaster PM ON ATP.PortfolioId = PM.PortfolioId
	AND PM.IsActive = 1
INNER JOIN QuestionComplexity QC ON QM.ComplexityId = QC.QuestionComplexityId
	AND QC.IsActive = 1
INNER JOIN dbo.Center c ON QM.CenterId = c.CenterId
INNER JOIN dbo.PGU p ON QM.PguId = p.PGUId
INNER JOIN dbo.Skill s ON QM.SkillId = s.SkillId
WHERE QM.CenterId = 1
	AND QM.IsReviewed = 1
	AND QM.IsActive = 1
	AND QM.Created_UploadedOn >= '2016-10-01'
GROUP BY p.NAME
	,s.SkillName
	,ATP.ActivityXTypeXPortfolioId
	,QC.NAME