Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
3. Library Book Checkout Percentage (Easy)
On this page

Problem Statement

Table: Patrons
Each row in this table represents an individual library patron, detailing their unique ID and name.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| patron_id   | int     |
| patron_name | varchar |
+-------------+---------+
patron_id is the primary key for this table.
Each row contains the name and the ID of a library patron.

Table: Checkouts
This table tracks the checkout records of books by patrons, including the book ID and the patron ID who checked out the book.

+-----------+----------+

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page