Yello! Pick me! 🙂

select UserID, sum(ServerInstanceCount) OVER (Partition by UserID) as UserServerCount from User u join ServerInstance si on u.Id = si.UserId;