select s.session_id, s.subject_id, s.percent_score, to_char(s.completed_datetime, :format) as completed_datetime, p.first_names || ' ' || p.last_name AS subject_name, :assessment_id as assessment_id from as_sessions s, persons p, (select max(s2.session_id) as session_id, s2.subject_id from as_sessions s2, cr_revisions r where r.item_id = :assessment_id and s2.assessment_id = r.revision_id and s2.completed_datetime is not null group by s2.subject_id) sub where s.session_id = sub.session_id and sub.subject_id = p.person_id order by s.completed_datetime