I am using MySQL and the answers I've found previously on this site did not work.

1. List the customer number for each customer in the CUSTOMERS table, along with the city and state in which the customer lives.

Answer:

1. Create a list containing the publishers name, the person usually contacted, and the

publishers telephone number. Rename the contact column Contact Person in the

displayed results. (Hint: Use the PUBLISHERS table.)

Answer:

1. List the customer number from the ORDERS table for each customer who has placed an order with the bookstore. List each customer number only once.

Answer:

1. Create a list of authors that displays the first name followed by the last name for each author. The last names and first names should be separated by a blank space.

Answer:

2. List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading Item Total in the output.

Answer: