hi experts.
i am working on search engine program, and i need an sql statement that i found hard to do.
table student:
student_name course_name
data:
mike algebra
mike english
sandy english
sam english
sam algebra
sql: get all students that have courses Algebra AND English in the same time.