2. 3. 5. 6, 7. 8. 9. 10. Display the name, and address of persons who live in the city of Portland. The output should have column headings "Name" and "Address", and respectively display first name and last name separated by a space, and address and city separated by comma and space. (104 rows) Compute the total number of books for each subject. Output the subjectid together with its total number of books, in decreasing order of total number of books. (16 rows) Display the first name, last name and city of persons who borrowed any book. There should not be any duplicate records in your result. (128 rows) a. Write your query without using the JOIN operator keyword or any sub-query. b. Write your query using the JOIN operator. c. Write your query using an IN sub query. Are there books that belong to on the subject 'Databases' that are written by more than 2 authors (in whatever role)? Display the bookdescid and title of these books. (0 rows) The dates in relation "borrow" are stored as REAL type data in Julian Days. You can use the built-in date() function to convert the real value into date format. For example, to find out a duedate as YYYY- MM-DD format you can use date(duedate). Find out the borrowers who returned the books after the due dates. Display book title, "borrower name" (concatenated first name and last name), date of return, due date, and how many days were delayed from the due date. Display the dates in YYYY-MM-DD format. (33 rows) Find out the books that have never been borrowed. Display the book titles along with the year of publication, ordered alphabetically by title and then from newest to oldest. (296 rows) Find out the authors (including co-authors) who have written (in the "Author" role) more than one book. Display the first name, last name of authors and their role along with the book title, ordered alphabetically by the last name and then first name of authors. (151 rows) A person is reading books about Networks (title containing the string 'network' in any case). They want to find books on the topic co-written (in whatever role) by ONLY 'Tim Miller' and 'Jason Noel' (no other authors). Display the titles of these books. (0 rows) Find all OTHER books written by the author of the book with title 'COMPUTER SCIENCE'. Display the title, "Author Name" (first name and last name), and year of publication of OTHER books by the same author(s). (1 row) Find out the persons who borrowed books on the subject of "Image Processing". Display borrower name (first and last names, separated by a space) under the column heading of "Borrower", book title, book subject, borrow date, and return date. Borrow and return dates should be in the YYYY-MM-DD format. (5 rows)