Can you please help me come up with the codes to make a query for number 1-6?

Assignment 5-SQL Queries Create SQL queries on JustLeeBooks Database based on the following requirements 1. Determine the profit generated by each book. List ISBN and Title. Please 2. List Customer FirstName, LastName, and Total Number of Orders for 3. Determine the average retail price of books for publisher 3, 4, and 5. List 4. List the customers who have placed an order totaling more than $30. note that Profits Retail-Cost Customers with more than one order. Publisher Name and Average Retail Price. Exclude customers living in CA, TX, and ID. List FirstName, LastName of Customer and Order Total. 5. What is the retail price of the most expensive book written by Janice Jones? List Author First Name, Last Name, and Retail Price of the Book. Cut-and-Paste Queries and Results on a Word document (HWs_ YourName). Note: This assignment may be time consuming, Please start carly and let me know if you have any questions