JOINS - Cartesian Product
44.2
Exercise

Cartesian product using JOINs

Write a query to display all the combinations of book names and author names, and for each combination, display a boolean value (0/1) that shows whether the book is written by the author.

Set the headers for the name of book, name of author and boolean for whether the book was authored by the writer as book, author and authored respectively.