Into Statement  «Prev  Next»

Complex SQL Statements - Exercise

More complex SQL Statements in Practice

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

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.