what is the course id of English course?
select course_id from courses where course_name = "English"
name the student ids who attend the statastic course?in order of attendance date
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
which student id attend english and french both course?
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 = "English" intersect 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 = "French"