Database: cre_Students_Information_Systems
Question: What are the distinct descriptions of all the detentions which have ever happened?
SQL:
SELECT distinct(T1.detention_type_description) FROM Ref_Detention_Type AS T1 JOIN Detention AS T2 ON T1.detention_type_code  =  T2.detention_type_code