# Post Success After Failure — Aced (formerly Exponent)

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/3976/post-success-after-failure
Source observed: 2026-11-04T23:17:43.485Z
Last checked: 2026-11-04T23:17:43.485+00:00
Indexed: 2026-11-06T04:56:23.872+00:00

---

# Post Success After Failure

**Difficulty:** Hard  
**Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)  
**Interview history:** 1 interview; last asked 2 years ago

We provide this SQL interview question for practicing analysis of sequential user activity. Detailed company statistics require an [upgrade](https://www.aced.io/upgrade?src=questions). No community answers have been contributed yet.

## Question

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 SQL that shows each user's post success rate (%) when the user's previous post had failed.

Return these columns:

- `user_id`
- `next_post_sc_rate`: the success rate of a post when that user's previous post had failed

Order the results by increasing `next_post_sc_rate`.

## Related questions

- [Post Success By Age Group](https://www.aced.io/questions/3962/post-success-by-age-group)
- [Post Success By Interface](https://www.aced.io/questions/3961/post-success-by-interface)
- [Monthly Post Success Analysis](https://www.aced.io/questions/3955/monthly-post-success-analysis)

## Practice controls

The question interface includes **Question**, **Solution**, and **Community** tabs, with an editor and output/test-results panels. You must [sign up to run code](https://www.aced.io/signup?src=lesson).

## About Aced

We offer interview preparation through courses, practice questions, interview loops, experiences, coaching, and related career services. Our course areas include Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineering, TPM, Solutions Architecture, UX/Product Design, and BizOps & Strategy.

---

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