How to fix an error in an MsSQl procedure?

Question

Stored procedures

Hi all!
I can't figure out the error I get
this error:

Столбец "PersonalType.Title" недопустим в списке выбора, поскольку он не содержится ни в агрегатной  функции, ни в предложении GROUP BY.

And here is the procedure code:

CREATE PROCEDURE GetObjectPersonalAnalysis
@ObjectId BIGINT
AS
BEGIN
    SELECT
    p.PersonalTypeId,
    pt.Title,
    SUM(p.Fact) as Fact,
    SUM(p.[Plan]) as [Plan],
    ( SUM(p.[Plan]) - SUM(p.Fact) ) as Deficit,
    (
        CASE
            WHEN SUM(p.Fact) > SUM(p.[Plan]) THEN ((SUM(p.[Plan])) / (SUM(p.Fact))) * 100 
            WHEN SUM(p.Fact) < SUM(p.[Plan]) THEN ((SUM(p.Fact)) / (SUM(p.[Plan]))) * 100
            ELSE 100
        END
    ) as MAPPING
  FROM Personals p 
    JOIN PersonalType pt
    ON p.PersonalTypeId = pt.Id
    WHERE (p.OrganizationDepartmentId = @ObjectId ) OR (p.OrganizationId = @ObjectId AND (p.OrganizationDepartmentId = 0 OR @ObjectId IS NULL))
    GROUP BY p.PersonalTypeId;
END

Answer 1

GROUP BY p.PersonalTypeId;

GROUP BY p.PersonalTypeId, pt.Title