In the SQL exercises, you will be given a data set and asked to write SQL queries to answer questions about the data. You can access SQL Developer Web to write and test your queries. Once satisfied, enter your query to the quiz. - One attempt - Submit the query only. Do not include any narratives nor outputs. - Access to SDW through your credentials and URL provided by email. - Schema: JUSTLEE - Put schema name and dot before table name to refer to tables in the schema; e.g., select * from justlee.customers ; List all authors whose first name contains the letter pattern "IN." Put the results in order of last name, then first name. List each author's last name and first name List name and contact of publishers whose pubid is either 1,2 , or 5 Which customers live in New Jersey? List each customer's last name, first name, and state Use a search pattern 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. Finds all orders placed before April 5, 2009 that haven't yet shipped