1. students
--------------------------------
|student_id|first_name|last_name|
---------------------------------

SELECT books.name AS "book name", students.*
FROM  books
JOIN borrowings ON books.book_id = borrowings.book_id
JOIN students ON students.student_id = borrowings.student_id;