Into Statement  «Prev  Next»

Complex SQL Statements - Exercise

More complex SQL Statements

Objective:Create a SQL statement to return the phone number by selecting the Firstname and Lastname from the table below.
Given the following table named Customer:

Lastname Firstname PhoneNumber ZIP Code
Brown Charlie 520-555-1212 85744
Brennan Jeffrey 123-321-5678 04325
Elizabeth Caitlin 444-231-5642 95439
Wilson Chris 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.