Only Question # 3 is need it in SQL commands.

Onelogin x Unit 3 Assignment A-QMBZ3X Get Homewaric Help With Cho X For Each Assignment You Will x G For each assignment you will x + - X e bconline.broward.edu/d2I/Ims/dropbox/user/folder_submit_files.dzl?db=530901&grpid=0&isprv=0&bp=0&ou=438301 Jetblue email SOL Commands Assignments Unit 3 Assignment A Unit 3 Assignment A Hide Assignment Information Instructions For each assignment you will login to Oracle Apex and write your queries. The query you write will be on the top half of the screen and the results will be shown on the bottom after you click the "Run" button. Upload a single MS Word Document with the queries that answer the problems listed below. 1. List the book categories and the average book price of each category. 2. 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 order date. If more than one book was ordered, sort the results by profit amount in descending order. Perform the search using the customer name, not the customer number. 3. Which books were written by an author with the last name Adams? Perform the search using the author name. Due Date Feb 1, 2020 8:36 PM Cub Assiemment Cancel Submit 6:39 PM Type here to search OBI e DE 9