Question 1
Consider the instance of the student_marks table in the IIT Madras BS degree database, as shown in Table 1.
| roll_no | course_id | assignment_id | marks |
|---|---|---|---|
| 21f12 | CS2001 | Quiz-1 | 65 |
| 21f12 | CS2001 | Quiz-2 | 72 |
| 21f12 | CS2001 | End-Term | 79 |
| 21f13 | CS2001 | End-Term | 81 |
| 21f13 | CS2001 | Quiz-2 | 90 |
| 21f11 | CS2001 | Quiz-1 | 59 |
| 21f11 | CS2001 | End-Term | 95 |
Table 1: student_marks
The professor is interested in the data shown in Table 2.
| roll_no | Quiz1 | Quiz2 | EndTerm |
|---|---|---|---|
| 21f11 | 59 | null | 95 |
| 21f12 | 65 | 72 | 79 |
| 21f13 | null | 90 | 81 |
Table 2: student_marks
Which of the following SQL queries will produce the resultant data shown in Table 2