# SQL interview question: count geography-book checkouts by user age

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/6290/find-users-geography-checkout-by-age
Source observed: 2026-11-04T23:11:22.077Z
Last checked: 2026-11-04T23:11:22.077+00:00
Indexed: 2026-11-06T04:09:29.541+00:00

---

# Given users, books, and checkout data, find the number of users who checked out books in the geography category grouped by age

We publish interview-preparation questions for technical roles. This question asks you to use users, books, and checkout data to count users who checked out books in the **geography** category, grouped by **age**.

## Question details

- **Role:** [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- **Company:** [Meta](https://www.aced.io/questions?company=meta-facebook)
- **Categories:** [Data Analysis](https://www.aced.io/questions?type=data-analysis), [SQL](https://www.aced.io/questions?type=sql)
- **Reported last asked:** 7 months ago
- **Detailed company statistics:** [Upgrade](https://www.aced.io/upgrade?src=questions)

The question is marked complete when an answer is submitted. You must [log in or sign up](https://www.aced.io/signup?src=nav&returnPath=/questions/6290/find-users-geography-checkout-by-age) to answer.

## Interview experiences

One interview experience is shared for this question:

### [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.

## Related question

- [Query overdue books per user](https://www.aced.io/questions/6289/query-overdue-books-per-user): Given a library-style schema with books, users, and check-in/check-out data, write a query to find for each user the number of books they checked out and did not return before the due date, and ret...

## Related courses

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

![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)

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course includes mock interviews, frameworks, and advice from senior candidates, with practice in data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

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

![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)

We help engineers prepare for senior-plus behavioral interviews at FAANG and Tier-1 companies. The course is made with staff and principal engineers from Meta, Netflix, Google, and more, and covers avoiding downleveling, elevating past projects, and communicating naturally.

## Our interview-preparation offerings

We offer preparation across product management, forward-deployed engineering, engineering management, software engineering, system design, data science, machine learning, and data engineering. We also offer AI engineering, investment banking, generative AI, security engineering, TPM, solutions architecture, UX/product design, and BizOps and strategy courses.

We provide interview questions, interview experiences, practice, mock interviews and coaching, resume review, salary negotiation, job referrals, resources, and related services through Aced, formerly Exponent.

## Your answer

Submit an answer to mark this question complete.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F6290%2Ffind-users-geography-checkout-by-age&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%2F6290%2Ffind-users-geography-checkout-by-age). Opening a form does not execute a tool.