Please answer the following SQL statements using the Pubs database in SQL Server:

$1.$ List the title and author name of all books.

$2.$ List the title and author name of all books not on business.

$3.$ List all stores who have bought the book $$But Is It User Friendly?$.$

$4.$ List all the books that have sold at least $20$ copies to a store.

$5.$ List how many stores bought the book $$Net Etiquette$.$

$6.$ List the publisher name and all authors who wrote books for the listed publisher.

$7.$ Write the SQL to verify that all titles are associated with a publisher $($outer query$).$

$8.$ What is the low range and the high range of royalties associated with a title.

$9.$ What are the unique job descriptions of employees and how many employees share each job description.

$10.$ List all titles which have not had any sales.