Project: Library Tracker
Analyze library data to find top borrowers, current checkouts, and inactive members using JOINs, aggregates, and filters.
You’ve learned SQL essentials like filtering, joining, grouping, and summarizing data. Now it’s your turn to apply your skills to a real-world scenario: managing a small library system.
Library tracker
In this project, you’ll analyze data from a community library system using SQL. You’ll work with two related tables:
The members table
ID | Name | MembershipDate |
1 | Ayesha | 2022-05-10 |
2 | Bilal | 2023-01-15 |
3 | Clara | 2021-11-20 |
4 | David | 2022-09-05 |
5 | Emma | 2024-02-18 |
The borrowed_books table
MemberID | BookTitle | BorrowDate | ReturnDate |
1 | The Alchemist | 2024-04-01 | 2024-04-10 |
2 | Atomic Habits | 2024-04-03 | 2024-04-12 |
1 | 1984 | 2024-04-15 | NULL |
3 | Thinking, Fast & Slow | 2024-03-20 | 2024-03-30 |
4 | The Lean Startup | 2024-04-18 | 2024-04-28 |
2 | The Alchemist | 2024-05-01 | NULL |
Let’s explore library activity and generate insights using SQL.
1. Most active borrowers
...