Rental;

+------+------+------------+------------+

| pID  | bID  | outDate    | inDate     |

+------+------+------------+------------+

|  201 |  101 | 2017-02-20 | NULL       |

|  201 |  103 | 2017-02-20 | NULL       |

|  201 |  104 | 2017-02-20 | NULL       |

|  201 |  105 | 2017-02-20 | NULL       |

|  201 |  101 | 2017-01-20 | 2017-01-27 |

|  201 |  108 | 2017-01-20 | 2017-01-27 |

|  202 |  107 | 2017-02-21 | NULL       |

|  202 |  108 | 2017-02-21 | NULL       |

|  203 |  105 | 2016-08-20 | 2016-08-27 |

|  203 |  106 | 2016-08-20 | 2016-08-27 |

|  203 |  101 | 2016-09-20 | 2016-09-27 |

|  203 |  103 | 2016-09-20 | 2016-09-27 |

|  204 |  107 | 2016-09-20 | NULL       |

|  205 |  103 | 2016-10-11 | 2016-12-11 |

|  206 |  108 | 2016-02-11 | 2016-02-13 |

|  206 |  108 | 2016-04-16 | 2016-05-13 |

+------+------+------------+------------+

 

Book;

+------+------------------------------------------+------+---------------------+

| bID  | title                                    | year | author              |

+------+------------------------------------------+------+---------------------+

|  101 | The Adventures of Tom Sawyer             | 1876 | Mark Twain          |

|  102 | The Great Gatsby                         | 1925 | F. Scott Fitzgerald |

|  103 | Brave New World                          | 1932 | Aldous Huxley       |

|  104 | Catch-22                                 | 1961 | Joseph Heller       |

|  105 | To Kill a Mockingbird                    | 1960 | Harper Lee          |

|  106 | Nineteen Eighty-Four                     | 1949 | George Orwell       |

|  107 | The Adventures of Huckleberry Finn       | 1884 | Mark Twain          |

|  108 | Harry Potter and the Philosopher's Stone | 1997 | J. K. Rowling       |

+------+------------------------------------------+------+---------------------+

 

Person;

+------+------------------+-------+

| pID  | name             | fine  |

+------+------------------+-------+

|  201 | Sarah Martinez   |  12.1 |

|  202 | Daniel Lewis     |     0 |

|  203 | Brittany Harris  |     0 |

|  204 | Mike Anderson    |    22 |

|  205 | Chris Jackson    | 25.15 |

|  206 | Elizabeth Thomas |  9.13 |

|  207 | Kristin Bailey   |     0 |

|  208 | Ashley White     |     0 |

+------+------------------+-------+

 

1. Find people that have checked out the same book more than once. Display the name of the person and the title of the book. Order alphabetically by name;

2. Find the book title that has been checked out the most often