Your boss would like you to answer some basic information about the JustLee bookstore business related to retrieving data from a database by using some basic SELECT statements. To determine the exact name of fields used in the tables for this project, he wants you to refer to the tables in the JustLee Books database, or use the DESCRIBE table name command to view the table$$s structure.

HINT: For each question, answer in two $(2)$ lines of code. Be sure to label your questions; copy and paste into a Word Document the code you used in Oracle for each question. Do NOT copy and paste screenshots of your Oracle page of code.

Display a list of all data contained in the BOOKS table.

List the title only of all books available in inventory, using the BOOKS table.

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

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

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

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.

Create a list of each book title stored in the BOOKS table and the category to which each book belongs. Reverse the sequence of the columns so that the category of each book is listed first.

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.

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.