Chapter 4 Exercise 1

1. List the customers who live in Chicago. (1)

SELECT Customers.CustomerID, Customers.LastName, Customers.Phone, Customers.Street, Customers.City, Customers.AccountBalance
FROM Customers
WHERE (((Customers.City)="Chicago"));