tell me course name for course id 301 and 302?
select course_name from courses where course_id = 301 or course_id = 302
Tell me the date of attendance for the student id 111 and 121?
select date_of_attendance from student_course_attendance where student_id = 111 or student_id = 121
How many students attend course English ?
select count ( * ) from courses as t1 join student_course_attendance as t2 on t1.course_id = t2.course_id where t1.course_name = "English"