Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
3. Library Book Checkout Percentage (Easy)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible