Task: Text to Code
Input (English): SQL: SELECT student_id FROM Student_Course_Attendance ORDER BY date_of_attendance Asc
Feedback: Make sure course in the statistics department .
Output (English): 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