Deletions

DELETE FROM PURCHASE

WHERE seller = “Joe” AND

product = “Brooklyn Bridge”

Factoid about SQL: there is no way to delete only a single

occurrence of a tuple that appears twice

in a relation.