Database: student_assessment
Question: What are the ids of the students who attended courses in the statistics department in order of attendance date.
SQL:
SELECT T2.student_id FROM courses AS T1 JOIN student_course_attendance AS T2 ON T1.course_id = T2.course_id WHERE T1.course_name = "statistics" ORDER BY T2.date_of_attendance