Write SQL queries for the following tasks.
1. Display the titles of books that never borrowed.
a. Write your query using OUTER JOINs.
b. Write the query again without using OUTER JOINs.
2. With which publisher(s) the author Alfred Aho published his book(s)? Display publishers' full
names.
3. Who are the authors published the books with MC GRAW-HILL publisher? Display the
firstname and lastname of the authors.
4. Display the first name and lastname of authors who wrote more than 3 books. Along with
each name, display the number of books as well.
5. Display the title of the book which has most physical copies. If there are more than one
book with the largest number of copies, show them all. Your query should show the number
of copies along with the title.