(Answer the following questions with SQL statement)

(1) Suppose a student with student id 88888 wants to take a course SEEM9999. Write a query to check if the student has taken all its prerequisites (directly and indirectly) already.

(2) For all students, show student id, student name, and all the course ids if a student has taken the same course more than once. (Hint, it happens if a student fails a course and repeats the course.)

student takes ID course_id sec id semester year grade ID name dept_name tot cred section course course id sec id semester year building room_no time_slot_id course_id title dept_name credits department dept_name building budget advisor s id i id time_slot time_slot_id day start time end_time classroom building room no capacity prereq course_id prereg_id instructor ID name dept_name salary teaches ID course_id sec_id semester year student takes ID course_id sec id semester year grade ID name dept_name tot cred section course course id sec id semester year building room_no time_slot_id course_id title dept_name credits department dept_name building budget advisor s id i id time_slot time_slot_id day start time end_time classroom building room no capacity prereq course_id prereg_id instructor ID name dept_name salary teaches ID course_id sec_id semester year