Using the database, answer the questions in SQL

Table List: advisor(s_ID, i_ID) classroom(building, room_number, capacity) course(course_id, title, dept_name, credits) department(dept_name, building, budget) instructor(id, name, dept_name, salary) prereq(course_id, prereq_id) section(course_id, sec_id, semester, year, building, room_number, time_slot_id) student(ID, name, dept_name, tot_cred) takes(ID, course_id, sec_id, semester, year, grade) teaches(ID, course_id, sec_id, semester, year) time_slot(time_slot_id, day, start_hr, start_min, end_hr, end_min)

1. Students (IDs and names) along with info about courses (course_ids) they took more than 1 time.

2. Advisors (their IDs and names) of the Computer Science department along with info about students (their IDs and names) they advise. Returned data should be ordered in a specific way. The first few tuples should show all students of a specific advisor. The next few tuples should show all students of some other advisor etc. Sample tuples that could appear in the result: 12121 | Korth | 101 | Green, 12121 | Korth | 103 | Brown, 12121 | Korth | 207 | Snow, 15151 | Silberschatz | 423 | Brandt. It is the case then, that at the top of the table we can see info about students advised by 12121 Korth, later on, we can see info about students advised by 15151 Silberschatz.

3. Credit hours each instructor taught in the Fall semester 2009. Ignore instructors who didn't teach in that semester.