I know I could do this with a PL/SQL cursor to iterate over the list of existing agent_ids but I was wondering I could do this with pure SQL using a combination of DISTINCT and SELECT INTO.