select s.session_id, s.subject_id, s.percent_score, to_char(s.completed_datetime, :format) as completed_datetime, p.last_name || ', ' || p.first_names 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 $start_date_sql $end_date_sql order by s.completed_datetime select sum(coalesce(points,0)) from as_item_data where session_id=:session_id select sum(coalesce(i.points,0)) from as_items i, as_item_data d where d.session_id = :session_id and i.as_item_id = d.as_item_id