Q&A about the site for serious players and enthusiasts of chess
-- Assuming the name or description for questions in the PostTypes table is "Question" SELECT MAX(p.CommentCount) AS MaxCommentsOnQuestion FROM Posts p JOIN PostTypes pt ON p.PostTypeId = pt.Id WHERE pt.Name = 'Question';