Using the database, answer 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)

A) Courses (IDs and titles) with their prerequisites (IDs and titles).

B) Instructors (IDs and names) and the number of students they taught. Ignore instructors who were never assigned to teach any course section.

C) The biggest number of different teachers that taught some course.