SELECT count(DISTINCT student_id) FROM Students_in_Detention
How many distinct students have been in detention?
SELECT count ( DISTINCT student_id ) FROM Students_in_Detention
select count ( distinct student_id ) from students_in_detention
How many distinct students have been in detention ?