takes ID course_id sec id semester student ID name dept_name tot_cred year grade advisor section course id sec_id semester year building room_no time_slot_id course course id title dept_name credits department dept_name building budget 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 teache ID course_id sec_id semester year Consider the following query: Find IDs of instructors who teach the courses ran in Fall Semester (Fall') or Spring Semester (Spring') in year 2020.- a) Answer this query using set operations." b) Answer this query using joins and selections. You should not use nested SQL or derived relation. 4 c) Answer this query using a nested query with correlation variables.- d) Answer this query using a nested query without correlation variables. H e) Answer this query using derived relations." (Please answer all in SQL. Example: Select * from instructor)