Using nested queries can help uncover which individuals are a particular job role at a company during a particular time range.