# SQL Question: Count Overdue Books by User

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/6289/query-overdue-books-per-user
Source observed: 2026-11-05T00:43:46.857Z
Last checked: 2026-11-05T00:43:46.857+00:00
Indexed: 2026-11-07T03:02:35.322+00:00

---

# Count overdue books by user

We publish this SQL interview question for a library-style schema containing books, users, and check-in/check-out data.

## Question

Write a query that returns, for each user:

- the username; and
- the number of books that user checked out and did not return before the due date.

The question is categorized as **SQL**, associated with the **Data Engineer** role, and associated with **Meta**.

[Upgrade to unlock detailed company stats](https://www.aced.io/upgrade?src=questions)

## Interview details

- **Reported last asked:** 7 months ago
- **Interview count:** 1

## Interview experience

[Meta · 7 months ago](https://www.aced.io/experiences/meta-facebook-senior-data-engineer-interview-f71127)

> I interviewed for Meta IC5 Senior Data Engineer, and the process felt hard but achievable if you prepare the right way. The first big hurdle was a live 1-hour CoderPad screening with 3 SQL and 3 Python questions, and the hardest part by far was the time pressure. After that, the onsite was four rounds and felt much more analytical than other DE or backend loops I've done, especially around SQL, data modeling, and tradeoff thinking. The round that stood out most was designing an Uber-style data model and then defending scaling choices like bucketing and hash-based partitioning once the table size went past 1 TB. Overall, it felt very SQL-heavy and very focused on whether I could show real technical depth, not just solve toy problems.
>
> **Data Engineer · Senior / L5**

## Community answers

No answers have been contributed by the community yet. Sign in or create an account to submit an answer.

## Related questions

- [Find users who checked out geography books, grouped by age](https://www.aced.io/questions/6290/find-users-geography-checkout-by-age)
- [Sum completed rides and deliveries for each ZIP code](https://www.aced.io/questions/2219/sql-query-sum-rides-deliveries-zipcode)

## Related courses

### [Data Engineering Interview Prep](https://www.aced.io/courses/data-engineering)

Land your dream data engineering role at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. Learn from mock interviews, frameworks, and advice from senior candidates. Practice data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

### [Behavioral Interviews: A Practical Guide for Engineers](https://www.aced.io/courses/eng-behavioral)

Get offers at the level you deserve. Prep for senior+ behavioral interviews at FAANG and Tier-1 companies. Made with staff and principal engineers from Meta, Netflix, Google, and more. Avoid downleveling, elevate past projects, and stop sounding like a robot.

![Behavioral Interviews: A Practical Guide for Engineers](https://images.ctfassets.net/x78yjrjc11pq/47qcoHjzFZXE37GoacedkB/9d8e3f4910d8b06b21e76745cd9cbff3/AdobeStock_1142146335.jpeg?w=800&h=800&fm=webp&q=75)

## Your answer

Submitting an answer marks this question complete. Sign in or create an account before answering.

## Browse Aced

We are Aced, formerly Exponent. Our interview-preparation catalog includes:

- [Courses](https://www.aced.io/courses?src=nav)
- [Loops](https://www.aced.io/guides?src=nav)
- [Experiences](https://www.aced.io/experiences?src=nav)
- [Questions](https://www.aced.io/questions?src=nav)
- [Practice](https://www.aced.io/practice?src=nav)
- [Coaching](https://www.aced.io/coaching?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)
- [Job referrals](https://www.aced.io/jobs/referrals?src=nav)
- [Blog](https://www.aced.io/blog?src=nav)
- [Resources](https://www.aced.io/resources?src=nav)

Our course areas include [Product Management](https://www.aced.io/courses/pm?src=nav), [Forward Deployed](https://www.aced.io/courses/forward-deployed-engineering?src=nav), [Engineering Management](https://www.aced.io/courses/engineering-management?src=nav), [Software Engineering](https://www.aced.io/courses/software-engineering?src=nav), [System Design](https://www.aced.io/courses/system-design-interviews?src=nav), [Data Science](https://www.aced.io/courses/data-science?src=nav), [Machine Learning](https://www.aced.io/courses/ml-engineer?src=nav), [Data Engineering](https://www.aced.io/courses/data-engineering?src=nav), [AI Engineering](https://www.aced.io/courses/ai-engineering?src=nav), [Investment Banking](https://www.aced.io/ib?src=nav), [Generative AI](https://www.aced.io/courses/gen-ai-interviews?src=nav), [Security Engineer](https://www.aced.io/courses/security-engineer?src=nav), [TPM](https://www.aced.io/courses/tpm?src=nav), [Solutions Architect](https://www.aced.io/courses/solution-architect-interview?src=nav), [UX / Product Design](https://www.aced.io/courses/product-designer-interview?src=nav), and [BizOps & Strategy](https://www.aced.io/courses/bizops?src=nav).

[Sign up](https://www.aced.io/signup?src=nav) or [log in](https://www.aced.io/login?src=nav).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F6289%2Fquery-overdue-books-per-user&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F6289%2Fquery-overdue-books-per-user). Opening a form does not execute a tool.