sqlite> select * from Enrolled;
sid         cid         grade
----------  ----------  ----------
45          CS 133      A
67          CS 133      A
78          CS 133      B
42          CS 133      B-
67          CS 60       B+
45          CS 105      A
sqlite> CREATE TEMPORARY TABLE CS60 AS SELECT * FROM Enrolled WHERE cid="CS 60";
sqlite> SELECT * FROM CS60;
sid         cid         grade
----------  ----------  ----------
67          CS 60       B+
sqlite> DELETE FROM Enrolled WHERE cid = "CS 60";
sqlite> SELECT * FROM CS60;
sid         cid         grade
----------  ----------  ----------
67          CS 60       B+
sqlite> select * from Enrolled;
sid         cid         grade
----------  ----------  ----------
45          CS 133      A
67          CS 133      A
78          CS 133      B
42          CS 133      B-