For order 1, list each book title and quantity ordered. Columns: title, quantity.

Answer

SELECT b.title, oi.quantity FROM order_items oi JOIN books b ON b.id = oi.book_id WHERE oi.order_id = 1;