The WHERE Clause 2
Q:
Get the Customers at 100 Main Street, New York.
SELECT firstName, lastName, street, city
FROM Customers
WHERE street='100 Main St.'
AND city='New York';