Tizes question covers Sector 3 and 4 of Bioct.3. It assesser our ahity to Internet and in write pas .SOT MIR ve Serinn 3 of Bin 2) This QURO 250 R rst database. (a) For each of the following give a request (or problem statement that the query can be used to answer (1) SELECT DISTINCT student_id FROM examination WHERE examination.course_code IN (SELECT course_code FROM course WHERE credit = 30) SELECT student_id, assignment.course_code, assignment.assignment number FROM assignment, (SELECT course_code, assignment_number, AVG(mark) AS average FROM assignment GROUP BY course_code, assignment_number) AS averagemarks WHERE assignment.course_code = averagemarks.course_code AND assignment.assignment number = averagemarks assignment number AND mark > average SELECT email address FROM statt UNION SELECT email address FROM student UNION SELECT email address FROM region (iv) SELECT student_id, course_code FROM examination WHERE mark > ALL (SELECT mark FROM assignment WHERE assignment.course_code = examination.course_code AND assignment student id = examination student_id) (b) For each of the following requests write a composite query (see Section 3 of Block 3) that will answer that request. In your answer, include a copy of the result of evaluating your query. (i) Give the course title and course code of any course which has more than one member of staff in the role of telephone tutor for that course. (ii) Give the student identifier and course code for each student who has submitted an assignment special circumstances form for the course, but has not submitted an examination special circunstances form for the same course