Display all of the data contained within the Customer table.

List only the customer name of all the customers in this database.

List the customer name and phone number for each customer. Use Phone$\_$Number as the heading for the contactphone field.

List the ID for each representative in the SupportRep table, along with their job title.

Create a list containing the product code and number of remaining licenses $($licenses generated minus licenses used$)$ for each product in the Product table. Rename the calculated column to Remaining in the displayed results.

Determine which product statuses are in use by products listed in the Product table. List each status only once.

Create a list of each possible ticket status code stored in the TicketStatus table and the description of each code. Write the query so that the description column is listed first.

List the first and last name of each support representative.

Create a list of support reps that combines the first and last names for each rep. The first names and last names should be separated by a blank space. Title this column Representative.

Modify the query from step $3$ to create a list of customers and their phone numbers. This list should display their name followed by colon $($:$),$ a blank space, and then their phone number in a single column. Name the resulting column Customer$\_$and$\_$Phone.