Show every author's name and the title of each of their books, INCLUDING authors with no books in stock list (use a LEFT JOIN from authors). Columns: name, title.

Answer

SELECT a.name, b.title FROM authors a LEFT JOIN books b ON b.author_id = a.id;