Write sql statement to answer following questions

Author( AuthorNum, AuthorLast, AuthorFirst) Book( BookCode, Title, PublisherCode, Type, Price, Paperback) Branch(BranchNum, BranchName, BranchLocation, NumEmployees) Inventory(BookCode, BranchNum, OnHand) Publisher(PublisherCode, PublisherName, City) Wrote(BookCode, AuthorName,Sequence)

6.List the titles of all of the books written by Stephen King.

7.List title, type and price for all books that are paperback.

8.List the branch name for all branches that have at least one book that has at least 10 copies on hand.

9.For each book, list the title, author first name and author last name. Print the list in reverse alphabetic order of the title.

10. List each publisher by name and how many books they published.