Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
23. Library Book Loans
On this page

Problem

Table: Books

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| book_id       | int     |
| title         | varchar |
+---------------+---------+
book_id is the primary key for this table.
Each row of this table contains the ID and the title of one book in the library.

Table: Loans

+---------------+---------+------+
| Column Name   | Type    | Note |
+---------------+---------+------+
| loan_id       | int     |      |
| book_id       | int     |      |
| user_id       | int     |      |
| loan_date     | date    |      |

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page