SELECT T1.teacher_id ,  T2.last_name FROM Detention AS T1 JOIN Teachers AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T1.detention_type_code  =  "AFTER" GROUP BY T1.teacher_id ORDER BY count(*) DESC LIMIT 1
Find the id and last name of the teacher that has the most detentions with detention type code "AFTER"?
SELECT T1.teacher_id , T2.last_name FROM Detention AS T1 JOIN Teachers AS T2 ON T1.teacher_id = T2.teacher_id WHERE T1.detention_type_code = `` AFTER '' GROUP BY T1.teacher_id ORDER BY count ( * ) DESC LIMIT 1
select t1 . teacher_id , t2 . last_name from detention as t1 join teachers as t2 on t1 . teacher_id = t2 . teacher_id where t1 . detention_type_code = value group by t1 . teacher_id order by count ( * ) desc limit value
Find the id and last name of the teacher that has the most detentions with detention type code `` AFTER '' ?