# Post Success By Age Group — 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/3962/post-success-by-age-group
Source observed: 2026-11-04T23:17:45.483Z
Last checked: 2026-11-04T23:17:45.483+00:00
Indexed: 2026-11-07T01:15:22.817+00:00

---

# Post Success By Age Group

We provide interview preparation through Aced, formerly Exponent. This medium-difficulty SQL question is for **Data Engineer**, **Data Scientist**, and **Data Analyst** roles, under **Coding** and **SQL**. It asks you to compare successful-post rates for young adults and non-young adults over time.

## Access and question status

Detailed company statistics require an [upgrade](https://www.aced.io/upgrade?src=questions). The question has been reported in **4 interviews** and was last asked **a year ago**. No community answers have been contributed. The interactive workspace includes **Question**, **Solution**, and **Community** tabs; an editor with **Output**, **Test Results**, and **Console** panels; and a [sign-up flow to run code](https://www.aced.io/signup?src=lesson).

## Problem

Write SQL that shows the difference in posting success rate between young adults, defined as age **0–18**, and non-young adults for each time period.

The requested output contains:

- `post_month`
- `ya_sc_rate`: young-adult posting success rate
- `non_ya_sc_rate`: non-young-adult posting success rate
- `diff`: `ya_sc_rate - non_ya_sc_rate`, rounded to **2 decimal places**

Results must be ordered by ascending month. Although the prompt also refers to calculating the rates by each week, its requested output and examples are monthly, using `post_month`.

## Sample data

### `post`

| post_id | post_date | user_id | interface | is_successful_post |
|---:|---|---:|---|---|
| 1 | 2024-01-05 | 1 | mobile | true |
| 2 | 2024-01-12 | 2 | web | false |
| 3 | 2024-01-20 | 3 | mobile | true |
| 4 | 2024-02-03 | 4 | web | true |
| 5 | 2024-02-14 | 1 | mobile | false |
| 6 | 2024-02-22 | 5 | web | true |

### `post_user`

| user_id | user_type | age |
|---:|---|---:|
| 1 | standard | 16 |
| 2 | standard | 34 |
| 3 | premium | 12 |
| 4 | standard | 45 |
| 5 | premium | 28 |

## Expected example output

| post_month | ya_sc_rate | non_ya_sc_rate | diff |
|---:|---:|---:|---:|
| 1 | 1.00 | 0.00 | 1.00 |
| 2 | 0.00 | 1.00 | -1.00 |

### Explanation

- **Month 1:** Young adults are users 1 and 3, ages 16 and 12. They made two posts, both successful, producing `ya_sc_rate = 1.00`. Non-young adult user 2, age 34, made one unsuccessful post, producing `non_ya_sc_rate = 0.00`. The difference is `1.00 - 0.00 = 1.00`.
- **Month 2:** Young adult user 1, age 16, made one unsuccessful post, producing `ya_sc_rate = 0.00`. Non-young adults are users 4 and 5, ages 45 and 28. They made two successful posts, producing `non_ya_sc_rate = 1.00`. The difference is `0.00 - 1.00 = -1.00`.

## Related SQL questions

- [Post Success By Interface.](https://www.aced.io/questions/3961/post-success-by-interface)
- [Post Success After Failure](https://www.aced.io/questions/3976/post-success-after-failure)
- [Monthly Post Success Analysis.](https://www.aced.io/questions/3955/monthly-post-success-analysis)

## Related courses

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

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

Ace data analyst interviews for product, marketing, and business analyst roles. We cover real take-home case studies, technical and dashboarding skills, and strategies from interviewers at technology companies and startups.

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

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

Prepare for data science roles at Google, Amazon, Microsoft, Meta, Apple, and other companies with mock interviews, frameworks, and advice from senior candidates. Topics include statistics, experimentation, coding, SQL, machine learning, behavioral interviews, and more.

## Other Aced offerings linked from navigation

We offer interview courses and preparation across Product Management, Forward Deployed Engineering, Engineering Management, Software Engineering, System Design, Data Science, Machine Learning, Data Engineering, AI Engineering, Investment Banking, Generative AI, Security Engineer, TPM, Solutions Architect, UX / Product Design, and BizOps & Strategy. We also offer Loops, Experiences, Practice, coaching, resume review, salary negotiation, job referrals, resources, and business and university programs.

- [Aced home — formerly Exponent](https://www.aced.io/?src=nav)
- [All questions](https://www.aced.io/questions)
- [Courses](https://www.aced.io/courses?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)
- [Log in](https://www.aced.io/login?src=nav)
- [Sign up](https://www.aced.io/signup?src=nav)

---

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