Your task is to answer the following questions. You must write the sou statements (query) and Run the query against the tables in BOOK database. Paste your query in English, soi command, and result into a notepad, word doc, or pdf using the following format Question 1: UST the Book code and book type for thoes books published by the publishercode 'JP' SELECT book_code, TYPE FROM book WHERE publisher_code='JP:; BOOK TYP 0808 MYS 8720PSY 9882 MYS Query 1: Ust the book code and book title for books of type FIC, MYS, and ART, and order the books by title. Query 2: Uist the book code and book title of each book that has the type MYS and a price of less than $20. Query 3: List the book code, book title, and price of each book with a price between $10 and $20. Query 4 : List the name of each publisher containing the word " and ". Query 5 : List the book code for books without a titie. Query 6: Ust the book code, book title, and book price. Order the books alphabetically and then by descending order of price. Query 7: List the count of distinct book types. Query 8: List the distinct book type and average book price for that type, further for only books in paperback, grouped by book type. Query 10: Uist the book type and average book price for paperback books having an average book price greater than $10