1. List the name of each publisher that’s not located in New York.

2. List the title of each book published by Penguin USA.

3. List the title of each book that has the type MYS.

4. List the title of each book that has the type SFI and that is in paperback.

5. List the title of each book that has the type PSY or whose publisher code is JP.

6. List the title of each book that has the type CMP, HIS, or SCI.

7. How many books have a publisher code of ST or VB?

8. List the title of each book written by Dick Francis.

9. List the title of each book that has the type FIC and that was written by John Steinbeck.

10. For each book with coauthors, list the title, publisher code, type, and author names (in the order listed on the cover).

11. How many book copies have a price that is greater than $20 but less than $25?

12. List the branch number, copy number, quality, and price for each copy of The Stranger.

13. List the branch name, copy number, quality, and price for each copy of Electric Light.

14. For each book copy with a price greater than $25, list the book’s title, quality, and price.

15. For each book copy available at the Henry on the Hill branch whose quality is excellent, list the book’s title and author names (in the order listed on the cover).