How many students attend course English?
create table student_course_attendance (course_id varchar, PRIMARY KEY (course_id)); create table courses (course_id varchar, course_name varchar, PRIMARY KEY (course_id))
select count(*) from courses as t1 join student_course_attendance as t2 on t1.course_id = t2.course_id where t1.course_name = "english"