Into Statement  «Prev  Next»

Complex SQL Statements - Exercise

More complex SQL Statements

Objective:Create an SQL statement to return the required information, and only the required information.
Given the following table named Customer:
Lastname Firstname PhoneNumber ZIP Code
Wynsoup Stephen 520-555-1212 85744
Brennan Jeffrey 123-321-5678 04325
Elizabeth Caitlin 444-231-5642 95439
Wynsoup Julie 201-453-7641 85744
Andrews Julie 309-123-4567 85744

Create a SELECT statement that will return the phone number for Chris Wilson. When you are done, submit your statement.