stores table:

books table:

QUESTION:

-- Fetch the id and isbn for all books that are assigned to a store, along with the name of the store they are assigned to

-- Books that are out of stock should still be included

-- Note: for each book we need the store name, not just the store_id

How to write the SQL code?

-- EXPECTED RESULTS -- -- 30205028802 Vancouver - 40205028802 Toronto - 100805073698 Montreal -- 120805073698 Toronto - 141250067057 Vancouver - 400205028802 Montreal