Mulder_ua

Я бы вынес машины и шефов в отдельные таблицы, что бы была 3тья форма но в данном случае это можно сделать так:

SELECT emplId
FROM EmployesInfo
WHERE ChiefId IN (
		SELECT emplId
		FROM EmployesInfo
		--Находим шефов
		WHERE emplId IN (
				SELECT ChiefId
				FROM EmployesInfo
				GROUP BY ChiefId
				--Что бы ему подчинялось >= 3 человека
				HAVING count(1) >= 3
				)
			--Уточняем что шеф не нищеброт и у него есть машина
			AND EmplCar IS NOT NULL
		)

Держи,

select source,
sum(case when datepart(mm, date) = 1 then amount else 0 end) as [Январь],
sum(case when datepart(mm, date) = 2 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 3 then amount else 0 end) aa [...],
sum(case when datepart(mm, date) = 4 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 5 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 6 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 7 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 8 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 9 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 10 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 11 then amount else 0 end) as [...],
sum(case when datepart(mm, date) = 12 then amount else 0 end) as [Декабрь]
group by source

Буду вопросы, задавай