select b.title, a.name
from book b join author a using (author_id)
|
|
| title |
name |
| Cat's Cradle | Kurt Vonnegut Jr. |
| Slaughterhouse Five | Kurt Vonnegut Jr. |
| Mother Night | Kurt Vonnegut Jr. |
| A Confederacy of Dunces | John Kennedy Toole |
| The Handmaid's Tale | Margaret Atwood |
| The Testaments | Margaret Atwood |
| Playing With Matches | Hannah Orenstein |
| Love at First Like | Hannah Orenstein |
| Head Over Heels | Hannah Orenstein |
|