# Monthly Post Success Analysis — 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/3955/monthly-post-success-analysis
Source observed: 2026-11-04T21:34:27.965Z
Last checked: 2026-11-04T21:34:27.965+00:00
Indexed: 2026-11-05T04:09:26.897+00:00

---

# Monthly Post Success Analysis

**Difficulty:** Easy  
**Format:** Coding · SQL  
**Associated roles:** [Forward Deployed Engineer](https://www.aced.io/questions?role=forward-deployed-engineer), [Data Engineer](https://www.aced.io/questions?role=data-engineer), [Data Scientist](https://www.aced.io/questions?role=data-science), [Data Analyst](https://www.aced.io/questions?role=data-analyst), [BizOps & Strategy](https://www.aced.io/questions?role=bizops)  
**Associated companies:** [ElevenLabs](https://www.aced.io/questions?company=eleven-labs), [LinkedIn](https://www.aced.io/questions?company=linkedin)  
**Reported:** 6 interviews; last asked 6 months ago

## Question

Write a SQL query that shows the total amount of successful posts per user type in the current month. Assume the current month is **November 2023**.

Your output must include:

- `user_type`
- `post_success`: number of successful posts
- `post_attempt`: number of posts
- `post_success_rate`: success rate in the range `0.00`–`1.00`

Order the results by descending success rate.

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

The question provides the prompt and schema; a solution is available through the locked Solution tab. The SQL editor includes Output, Test Results, and Console areas, and users can [sign up to run code](https://www.aced.io/signup?src=lesson). Detailed company statistics require [upgrading](https://www.aced.io/upgrade?src=questions).

## Interview experience

One experience is listed:

- [LinkedIn · a year ago](https://www.aced.io/experiences/linkedin-senior-bizops-strategy-interview-e0f9e9) — “It was amazing. Had lovely conversations and it was amazing. I got nervous towards the end and the panel understood hence was not rejected at last round.” **BizOps & Strategy · Senior / L5**

## Related questions

- [Post Success By Age Group.](https://www.aced.io/questions/3962/post-success-by-age-group)
- [Post Success After Failure](https://www.aced.io/questions/3976/post-success-after-failure)
- [Post Success By Interface.](https://www.aced.io/questions/3961/post-success-by-interface)

## Related courses

### [Product Strategy Questions](https://www.aced.io/courses/product-strategy)

![Product Strategy Questions](https://images.ctfassets.net/x78yjrjc11pq/5hHtTyOypgyKA7R3fxMlyl/dde193ecc09baabd8304c3aec25483f2/product_strategy_course_ab4d3cf294.jpeg?w=800&h=800&fm=webp&q=75)

Product strategy is fundamentally different in the AI era, and we explain how to approach these rounds effectively within the new rules.

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

Prepare for product, marketing, or business analyst interviews with real take-home case studies, technical and dashboarding practice, and strategies from interviewers at technology companies and startups.

## More from Aced

- [All questions](https://www.aced.io/questions)
- [SQL questions](https://www.aced.io/questions?type=sql)
- [Coding questions](https://www.aced.io/questions?type=coding)
- [Aced home](https://www.aced.io/?src=nav)

Aced, formerly Exponent, provides interview-preparation questions, courses, practice, coaching, and related career resources.

---

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