SQL Questions 3: Birdville Library

Table Design:

Book Table Book ID, BookCallNo, Title, AuthorFirst, AuthorLast, Place, Copyright, Publisher, Price, InOut, Fiction
Patron Table Patron ID, PatronFirst, PatronLast, Fines
Subject Table BookID, Subject

Write out the SQL Statement to answer the following questions.

  1. Print out the entire Patron Table.
  2. Print out the entire Subject Table
  3. Print out the names of people who live in Brampton.
  4. Print out the titles of books with a price over $20
  5. Print out the title of the fiction books.
  6. Print out the title of the books that are in the library.
  7. Print out the title and subject of all the books in the subject table.
  8. Print out the title and the patron name of all of the books that are out.
  9. Print out the title of the books whose subject is "Social History".
  10. Count the number of people who have library fines.
  11. Print out the number of books whose subject is "Lord of the Rings".
  12. Print out the number of books that have each subject.