Question

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 publisher’s name, the person usually contacted, and the

publisher’s 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:

Answer 1

Answer:

1)

Select customer , city, state From customers;

2)

Select name, contact as “Contact Person”, phone From publisher;

3)

SELECT DISTINCT customer# FROM orders;

4)

SELECT lastname || ‘, ‘ || firstname AS “Author Name” FROM author;

5)

SELECT item, item total * Paideach AS “Item Total” FROM order item;