use EnVisage

delete
from Team
where ManagerId not in (select Id from AspNetUsers)