college.rip
The project desk
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.csv

Check 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.

Use this brief in a learning route

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.