Question 3 30 marks 3.1 Use search pattem to find any book title with A for the second letter and N for the fourth letter. List each book's ISBN and title. Sort the list by title in descending order. (4 marks) 3.2 Determine the average retail price of Books by publisher name and category. Include only the categories Children and Computer, and the groups with an average retail price greater than $50. Use the JOIN ---USING ( keywords. (5 marks) 3.3 Based on the tables of the JustLee books database, determine the profit of each book sold to Jake Lucas using the actual price paid by the customer (not the book's regular 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 customer name, not the customer number. Create the query using the keywords (JOIN.... USING). (5 marks) 3.4 Create a view that list the name and phone number of the contact person at each publisher. Do not include the publisher's ID in the view. Name the view CONTACT. (3 marks) 3.5 Change the CONTACT view so that no users can accidentally perform DML operations on the (3 marks) View 3.6 Determine the total profit generated by sales to customer 1017. Note: quantity should be reflected in the total profit calculation. (5 marks) 3.7 Determine which books cost less than the average cost of other books in the same category. To perform this exercise, use subqueries. (5 marks) The End