what is the teacher id of detention id 1
select teacher_id from detention where detention_id = 1
for detention id 1
select datetime_detention_end from detention where detention_id = 1
what is the middle name of teacher id 1?
select t1.middle_name from teachers as t1 where t1.teacher_id = 1