Consider the following query: For all students, show students ID if he/she takes at least one FinTech course (a course id beginning with FETC) and at least one SEEM course (a course id beginning with SEEM) in 2020.

(a) Answer this query using SQL in which you must have set operations.

(b) Answer this query using SQL in which you must only use joins and selections excluding set operations, nested subquery, or derived relation.

(c) Answer this query using SQL in which you must use nested subquery without correlation variables.

(d) Answer this query using SQL in which you must use nested subquery with correlation variables.

(e) Answer this query using SQL in which you must use derived relations.

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