Assignment 7 Worth 50 points You must use the SQL files attached to the assignment to answer these questions. It is named "JLDB_Build 8.sql". Write the SQL statement needed to complete the task and add a screenshot of the output in Oracle. 1.) Display the last name, first name, and state of all customers that live in Florida, New York, Georgia, and illinois 2.) Display the order number and ship date for all orders that shipped after April 1, 2009. 3.) List the title and category for all books that are not in the Fitness category. 4.) Display all the customer information for customers that live in New York and California. Order by the customer's last name. 5.) 6.) Rework your answer from 5 to output the same data, but with different conditions in the WHERE clause. Ust the first name and tast name of all authors that have a last name that contains the characters "IN". Order the results by last name and then first name. Ust he ISBN and title for all books that have a title in which appears as the second character and "N" as the fourth Order by the title in descending order. 7.)