Question

Write a query against the ADDRESS table to select a list of names and phone numbers. The output should match these requirements:
The name column should contain both the first and last names with a blank
space
between them
Use the string concatenation.
The second column will contain the phone number.
A Phone number should be in the format (999) 999-9999. Use the SUBSTR function and CONCATENATE.
Order the query by last name then first name.​

Answer 1

Answer:

Write a query against the ADDRESS table to select a list of names and phone numbers. The output should match these requirements:

The name column should contain both the first and last names with a blank

space

between them

Use the string concatenation.

The second column will contain the phone number.

A Phone number should be in the format (999) 999-9999. Use the SUBSTR function and CONCATENATE.

Order the query by last name then first name.