1.Using the SUBSTRING and CONCAT functions, write a query to display each customer name as a single field in the format Jones, Tom with a heading of Customer along with the customer_phone field in a nicely formatted calculated column named Phone. For example, a record containing the customer_phone value 6145535443 would be output with parentheses, spaces, and hyphens, like this: (614) 555-5443. Sort by last name.

2. Create a statement to insert a new record with your values: your customer id, first name, last name, address, city, state, zip code p and fax number.

Customer id:

26

Your First Name

Your first Name

Your Last Name

Your last name

Your Address

3801 West Temple Avenue

Your City

Pomona

Your State

CA

Your Zip Code

91768

Your Phone

(909) 869-5209

Your fax

(310)555-6666