Homework Assignment #8 (Queries)

Consider this a preliminary assignment description. Depending on how much we get through in class on Thursday, I may add something extra to the end of the assignment. I'll update this after class on Thursday.

In this assignment, you will use the database you created for Homework #7 to run a few more complex queries.

Write queries to complete each of the following tasks:

  1. List the ID's of all patrons who have checked out more than one book.
  2. List the full names of all patrons who have checked out more than one book.
  3. List all the books, sorted by their average rating (descending).
  4. List all the books with an average rating of 7 or higher.

When you send in your e-mail, include the name of your database and your MySQL port number (so that your graders don't have to waste time looking it up). Also write down all of the queries (I mean, write down what you typed into MySQL to get the lists above), so that we can test them to see if they work as they're supposed to. Remember to make sure that MySQL is running so that your AI's can see the database you created and test your queries.

This assignment is due Monday, July 4th before class.