# High Volume Low Success — SQL 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/3956/high-volume-low-success
Source observed: 2026-11-04T21:34:34.163Z
Last checked: 2026-11-04T21:34:34.163+00:00
Indexed: 2026-11-05T02:41:52.675+00:00

---

# High Volume Low Success.

We provide this **Easy** SQL coding question for data-oriented interview preparation. It is tagged **Coding** and **SQL**, and the rendered page identifies it with **4 interviews** and “Reported last asked: a year ago.” The page includes tabs for **Question**, a locked **Solution**, and **Community 15**. No community answers have been contributed yet.

## Problem

You are given the following tables.

### `post`

| Column | Type |
|---|---|
| `post_id` | integer |
| `post_date` | timestamp |
| `user_id` | integer |
| `interface` | string |
| `is_successful_post` | boolean |

### `post_user`

| Column | Type |
|---|---|
| `user_id` | integer |
| `user_type` | string |
| `age` | integer |

Write a SQL query to isolate users who:

1. Post above the overall average total number of posts; and
2. Have a successful-post rate below the overall average.

The output must include:

- `user_id`
- `post_success` — number of successful posts
- `post_attempt` — number of posts
- `post_success_rate`

Order the results by decreasing success rate.

## Practice interface

The page includes an SQLite selector, an **Editor** and **Share** panel, and result tabs for **Output** and **Test Results**, plus a **Console**. The SQL solution is locked. We provide [sign-up access to run code](https://www.aced.io/signup?src=lesson), and detailed company statistics for this question are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

## Related courses

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

![Data Analyst Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/72OTqij57b2TklhaD2vrdV/be0dae6242904970d1696e5a4d858e18/AdobeStock_1357126576.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates ace data analyst interviews for product, marketing, or business analyst roles through real take-home case studies, technical and dashboarding practice, and strategies from interviewers at top technology companies and startups.

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

![Data Science Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/3U4C5C0OkDR0UeGch4AmlE/7ad489430b676a088cb973307fe77884/Data_Science_Interview_Prep_Course.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data science roles at Google, Amazon, Microsoft, Meta, Apple, and other companies with mock interviews, frameworks, and advice from senior candidates. Practice covers statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.

## Useful links

- [All Questions](https://www.aced.io/questions)
- [Data Engineer questions](https://www.aced.io/questions?role=data-engineer)
- [Data Scientist questions](https://www.aced.io/questions?role=data-science)
- [Data Analyst questions](https://www.aced.io/questions?role=data-analyst)
- [Coding questions](https://www.aced.io/questions?type=coding)
- [SQL questions](https://www.aced.io/questions?type=sql)

Aced was formerly known as Exponent.

---

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