DELETE FROM customers
WHERE firstName = 'John' AND lastName = 'Smith';