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)

11. How many books cost less than $10.00?

12. List the author last names for all the authors published by Simon and Schuster.

13. List each type of book and how many of each.

14. How many books are on hand at the Brentwood Mall location?

15. List each branch location, the number of employees and the number of books on hand.

16. List the titles of all books who have a Sequence number of 1. You must use a nested select statement.