takes ID course_id sec_id semester year grade student ID name dept_name tot_cred section course id sec id semester course course id title dept_name credits department dept_name building budget advisor sid i id year building room_no time_slot_id time_slot time slot id day start_time end_time prereq instructor classroom building room no capacity course_id prereg_id ID name dept_name salary teaches 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. H b) Answer this query using joins and selections. You should not use nested SQL or derived relation. A c) Answer this query using a nested query with correlation variables. + d) Answer this query using a nested query without correlation variables.' e) Answer this query using derived relations takes ID course_id sec_id semester year grade student ID name dept_name tot_cred section course id sec id semester course course id title dept_name credits department dept_name building budget advisor sid i id year building room_no time_slot_id time_slot time slot id day start_time end_time prereq instructor classroom building room no capacity course_id prereg_id ID name dept_name salary teaches 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. H b) Answer this query using joins and selections. You should not use nested SQL or derived relation. A c) Answer this query using a nested query with correlation variables. + d) Answer this query using a nested query without correlation variables.' e) Answer this query using derived relations