Current mentors w/o active agreements

gistfile1.sql

SELECT c.id, c.email, c.first_name, c.last_name
  FROM contacts c
 WHERE c.contact_type = 'Current mentor'
   AND NOT c.id IN (
        SELECT DISTINCT mentor_id
          FROM agreements a
         WHERE last_session is null 
        )
;