SELECT		i.FK_EmpID,
		e.Name,
		COUNT(DISTINCT s.Type + ' ' + s.Version) AS [Stove List]
FROM		STOVE AS s
INNER JOIN	INV_LINE_ITEM AS ili ON ili.FK_StoveNbr = s.SerialNumber
INNER JOIN	INVOICE AS i ON i.InvoiceNbr = ili.FK_InvoiceNbr
INNER JOIN	EMPLOYEE AS e ON e.EmpID = i.FK_EmpID
GROUP BY	i.FK_EmpID,
		e.Name

SELECT		i.FK_EmpID,
		e.Name,
		s.Type
		COUNT(DISTINCT s.Version) AS [Stove List]
FROM		STOVE AS s
INNER JOIN	INV_LINE_ITEM AS ili ON ili.FK_StoveNbr = s.SerialNumber
INNER JOIN	INVOICE AS i ON i.InvoiceNbr = ili.FK_InvoiceNbr
INNER JOIN	EMPLOYEE AS e ON e.EmpID = i.FK_EmpID
GROUP BY	i.FK_EmpID,
		e.Name,
		s.Type

SELECT		i.FK_EmpID,
		e.Name,
		s.Type,
		s.Version
		COUNT(*) AS [Stove List]
FROM		STOVE AS s
INNER JOIN	INV_LINE_ITEM AS ili ON ili.FK_StoveNbr = s.SerialNumber
INNER JOIN	INVOICE AS i ON i.InvoiceNbr = ili.FK_InvoiceNbr
INNER JOIN	EMPLOYEE AS e ON e.EmpID = i.FK_EmpID
GROUP BY	i.FK_EmpID,
		e.Name,
		s.Type,
		s.Version