USING SQL query where: WROTE ( BOOK_CODE, AUTHOR_NUMBER, SEQUENCE_NUMBER) AUTHOR ( AUTHOR_NUMBER, AUTHOR_LAST, AUTHOR_FIRST) BOOK (BOOK_CODE, BOOK_TITLE, PUBLISHER_CODE, BOOK_TYPE, BOOK_PRICE, PAPERBACK)

For each author, list the last name, first name, and title and book type of all books in inventory written by her or him.