Please answer with queries according to the database table above

CPAN 121 Assignment 2 - Joins (100 points) You are to use SQL Developer to perform the requested operations based on tables. You are to use comments to record your name, the assignment number, and the question number for all questions. There are multiple ways to answer these queries. You can choose any. Download and run JLDB_BUILD_1.sql AND JLDB_BUILD_11.sql before running the queries. (each query is 10 points) Question 1 Create a list that displays the title of each book and the name and phone number of the person at the publisher's office whom you would need to contact to reorder each book. Question 2 Determine which orders have not yet been shipped and the name of the customer who placed the order. You are to sort the results by the date on which the order was placed. Question 3 Produce a list of all customers who live in the state of Florida (FL) and have ordered a book about computers. Category is COMPUTERS. Display the customer's name, the book title, the order number and the category. Question 4 Determine which books Jake Lucas has purchased. Perform the search using the customer's last and first names and not he customer number or an individual part of the customer's name. If he has purchased multiple copies of the same book, unduplicate the results. Question 5 Determine the profit of each book sold to Jake Lucas, using the actual price the customer paid (not the book's regular retail price). Sort the results by the date of the order. If more than one book was ordered, sort the results by the profit amount in descending order. Perform the search by using the customer's full name and not the customer number or part of his name. Question 6 Which book was written by an author with the last name of Adams? Perform the search using the author's last name. Question 7 What gift will a customer who orders the book Shortest Poems receive? Use the actual book retail value to determine the gift. Question 8 Identify the author(s) of the books ordered by Becca Nelson. Perform the search using the customer's full name. Question 9 Display a list of all books in the BOOKS table. If a book has been ordered by a customer, also list the corresponding order number and the state in which the customer resides. Question 10 An EMPLOYEES table was added to the Just Lee database to track employee information. Display a list of each employee's name, job title, and manger's name. Use column aliases to clearly identify employee and manger name values. Include all employees in the list and sort by manager name. If you are missing the EMPLOYEES table you did not download the new script JLDB_11_BUILD.sql