# Bookstore database SQL joins and aggregations interview question

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/4776/bookstore-schema-sql-joins-aggregations
Source observed: 2026-11-04T21:34:38.496Z
Last checked: 2026-11-04T21:34:38.496+00:00
Indexed: 2026-11-05T02:52:26.019+00:00

---

# Bookstore database SQL joins and aggregations

We ask candidates to write SQL queries against a bookstore database schema. The queries should use joins and aggregations to answer questions about **sales, inventory, and customer data**.

## Question details

- **Role:** [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- **Companies:** [Meta](https://www.aced.io/questions?company=meta-facebook)
- **Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)
- **Interview count:** 2 interviews
- **Last asked:** 2 years ago
- **Saved by:** 6 users

The question includes an answer workflow: submitting an answer marks the question complete. Community answers are not currently available.

## Related courses

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

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course covers mock interviews, frameworks, advice from senior candidates, 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)

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

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

## Access

Detailed company statistics for this question are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F4776%2Fbookstore-schema-sql-joins-aggregations&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%2F4776%2Fbookstore-schema-sql-joins-aggregations). Opening a form does not execute a tool.