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)

1.List all the authors, first name and last name in alphabetic order of first name.

2.List all the cities that have a publisher, list each city only once.

3.How many book titles are in the database?4.For each branch, list the branch name and the total number of books on hand.

5.How many employees total work at Henry Books?