Need to count on specific field in employee listing

[Lou-Jean]

I have a file of Employee SSN, Last Name, First Name, Relationship. Relationship would be Employee, Spouse or Child.

SSN	Last_Name	First_Name	Rel_Cd
123456789	LName	Matthew	Employee
123456789	LName	Mary	Spouse
123456789	LName	Luke	Child
123456789	LName	James	Child

For each Employee record, I need a count of Spouse and/or Child records related to that Employee SSN.
I would prefer to retain all records, and just have the count listed next to the Employee in a new column.

[ranman256]

select SSN, count(SSN) as CountRelatives from tEmp where rel_cd <> "employee" group by SSN;

[NTC]

another approach; just make a query with SSN field only; press the big E sigma icon to make it an aggregate query where it will default the SSN field to 'Group By' and change that to Count. Because there must always be an employee all you need to do is subtract 1 from the count.......