Opening the paper…
Database Management Systems, Quiz 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
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 Figure from the original question paper Figure from the original question paper