select r.item_id as assessment_id, s.subject_id,
p.first_names, p.last_name
from as_sessions s, cr_revisions r, persons p
where s.session_id = :session_id
and r.revision_id = s.assessment_id
and s.subject_id = p.person_id
SELECT creation_datetime AS session_start,
completed_datetime AS session_finish,
completed_datetime-creation_datetime AS session_time
FROM as_sessions s
WHERE s.session_id = :session_id
SELECT COUNT(*)
FROM as_sessions s
WHERE s.subject_id = :subject_id
AND s.assessment_id = :assessment_rev_id
select s.section_id, cr.title, cr.description, ci.name, s.instructions,
s.feedback_text, m.max_time_to_complete, m.points
from as_assessment_section_map m, as_session_sections ss,
as_sections s, cr_revisions cr, cr_items ci
where ci.item_id = cr.item_id
and cr.revision_id = s.section_id
and s.section_id = m.section_id
and m.assessment_id = :assessment_rev_id
and m.section_id = ss.section_id
and ss.session_id = :session_id
order by ss.sort_order