select session_id, creation_datetime, completed_datetime
from as_sessions, cr_revisions
where item_id=:assessment_id
and assessment_id=revision_id
and subject_id=:subject_id
select count(*)
from as_sessions, cr_revisions
where item_id=:assessment_id
and assessment_id=revision_id
and subject_id=:subject_id