select assessment_name from as_assessments where assessment_id = :assessment_id select persons.first_names || ' ' || persons.last_name as name, parties.email from persons, parties where person_id = :user_id and person_id = party_id