Display the name, and address of persons who fail to provide their emails. 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. $(2$ marks, $187$ rows$)2.$ Compute the total number of books each publisher has published $($as Publisher role$).$ Output publisher full name together with its total number of published books, in decreasing order of total number of books. $(2$ marks, $194$ rows$)3.$ Display publisher full name of all publishers that have never published $/$ edited any books at all. There should not be any duplicate records in your result. $(2$ marks, $113$ rows$)$ a$.$ Write your query using the JOIN operator. b$.$ Write your query using an IN sub query. $4.$ The dates in relation $$borrow$$ are stored as REAL type data in Julian Days. Find out the books that were overdue for more than $10$ days when they were returned. Display book title, date of return, due date, and how many days were delayed from the due date. Display the dates in Australian date format. $(2$ marks, $19$ rows$)5.$ Find out books that have never been borrowed. Display the book bookdescid, titles along with the year of publication, sorted by year of publication from newest to oldest. $(2$marks, $295$ rows$)$ a$.$ Write your query using an EXISTS $/$ NOT EXISTS sub query. b$.$ Write your query using an IN $/$ NOT IN sub query. $6.$ Find out the borrowers who had borrowed $5$ or more books. Display $$borrower name$($Concatenated first name and last name$),$ and the number of books borrowed. $(2$ marks, $6$ rows$)7.$ Display the name of authors who have written most books. If there is more than one author with the equal highest number of written books, show them all. Your query should output full name of those authors. $(2$ marks, $5$ rows$)8.$ Find out the authors who are sole workers, i$.$e$.$ only work on their own and never cooperate with other people on books as co$-$author, co$-$translator, etc. Display authorID, author name $($first and last names, separated by a space$)$ under the column heading of "Author Name". There should not be any duplicate records in your result. $($This question is for ISYS$1055$ only; not required for ISYS$3412)(2$ marks, $321$ rows$)8.$ Display the list of editors who have edited books on the subject "Communications". Your query should display publisher's full name. $($This question is for ISYS$3412$ only; not required for ISYS$1055)$