Return the list of books from the catalog_book table, focusing on the title column. Associate the books with the authors by the primary key in the author_id column. Use the first_name column as the author's first name, and last_name as the last name.

SELECT title, first_name, last_name FROM catalog_book LEFT JOIN authors ON catalog_book.author_id = authors.id;