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