Using the Transcript table, write an SQL statement that

a. Deregisters the student with Id = 123456789 from the course CS305 for the fall of 2001
b. Changes to an A the grade assigned to the student with Id = 123456789 for the course CS305 taken in the fall of 2000
c. Returns the Id of all students who took CS305 in the fall of 2000

a. ```
DELETE
FROM Transcript
WHERE StudId = ’123456789’
AND CrsCode = ’CS305’ AND Semester = ’F2001’
```

b. ```
UPDATE Transcript
SET Grade = ’A’
WHERE StudId = ’123456789’
AND CrsCode = ’CS305’ AND Semester =’F2000’
```

c. ```
SELECT StudId
FROM Transcript
WHERE CrsCode = ’CS305’ AND Semester = ’F2000’
```