Kodewick
Start learning →
Basic←→0 / 70

Who borrowed what

#037BasicJOIN4 min

The loans table only has a book_id, so you can't tell which book it is. Join loans with books (loans.book_id = books.id) and pick the reader and the book's title, one row per loan.

The tables
books
idtitleauthorgenrepagesyear
1The Night GardenMia Lanestory2102015
2Stars for KidsTom Hartscience962020
3Lost at SeaMia Lanestory3402011
4Easy BreadRosa Bellfood1282019
5The Bug BookTom Hartscience642022
6Soup DaysRosa Bellfood1502008
7The Red KiteAnn Colestory1802021
8Rocks and RiversAnn Colescience2202017
8 rows
loans
idbook_idreaderdays
11Leo14
22Nora7
31SamNULL
44Leo21
55NoraNULL
63Ivy10
72Sam5
87Ivy12
8 rows
query.sql
-- your code here: JOIN books, then pick loans.reader and books.title
SELECT reader, book_id
FROM loans;
Ctrl + Enter runs too
Result

Run shows what your query gives. When it looks right, Submit.