ORIGINAL BRIEF · Data & SQL
Ask better questions of a library
Investigate a small, entirely fictional library loan file. Answer questions with SQL, show the query and explain the meaning of missing values.
THE FINISHED THING
A schema, import steps, at least three queries and a short findings note.
The boundaries
- The sample contains eight loan records.
- A blank returned_on means the sample has no recorded return, not proof of an overdue loan.
- Use loan_id as a unique key. Preserve book and borrower labels exactly.
- Treat sample_as_of as a fixed reference date; do not use today’s date to reinterpret this fictional snapshot.
Start with the sample.
Original fictional data, provided under CC0. It is not a real-world dataset.
Download library-loans.csvCheck your work
- There are eight loans and six distinct book IDs.
- Two records have no return date in the sample.
- Four loans are in the Fiction category.
- The report distinguishes a loan count from a count of unique books.
- Every headline can be reproduced with a saved query.
THE PART A SCREENSHOT CAN’T SHOW
Explain your decisions.
- What does one row mean?
- Which conclusion cannot be supported by this dataset?
- How could missing or duplicated rows change the result?
Use and adapt this original practice brief. Do not present copied work as your own or submit a provided solution to a graded course. Keep private information out of public evidence links.