Question

what sql statements does the following from a table like this? ex 2.4

course Id Name semester semester Grade

Answer 1

Solution

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';
---

all the best