To complete these exercises a new database environment will be created. Download the JLDB_Build.sql script and run it in SQL Developer. The script will create new database tables under your account, which you will be able to query to answer the following questions. IN ORDER TO GET FULL CREDIT YOUR QUERIES SHOULD RUN IN SQL DEVELOPER. I WILL CHECK YOU OWN SCHEMAS AS WELL.

Each question is worth 10 pts. 1. Write the SQL command to display a list of all data contained in the BOOKS table.

2. What SQL command will list the title only of all books available in inventory, using the BOOKS table.

3. List the title and publication date for each book in the BOOKS table. Use the column heading Publication Date for the Pubdate field.

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

5. 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 PUBLISHER table.)

6. Determine which categories are represented in the current book inventory. List each category only once.

7. 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.

8. Create a list of each book title stored in the BOOKS table and the category in which each book belongs.

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

10. 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.