# Reddit Users 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/3079/reddit-users
Source observed: 2026-11-04T23:34:36.367Z
Last checked: 2026-11-04T23:34:36.367+00:00
Indexed: 2026-11-05T11:00:00.973+00:00

---

# Reddit Users

**Difficulty:** Easy

We provide this SQL coding interview question about Reddit’s users, subreddits, and subscriptions. Reddit is described as a social platform where users join topic-focused communities called “subreddits,” subscribe to them, and post, comment, upvote, or downvote content.

## Question details

- **Interview count:** 1 interview
- **Last asked:** 3 years ago
- **Categories:** [Coding](https://www.aced.io/questions?type=coding), [SQL](https://www.aced.io/questions?type=sql)
- **Saved by:** 19 users

## Schema

### `user` table

| Column | Type |
|---|---|
| `user_id` | integer |
| `username` | string |
| `…` |  |

### `user_subreddit` table

| Column | Type |
|---|---|
| `user_id` | integer |
| `subreddit_id` | integer |

### `subreddit` table

| Column | Type |
|---|---|
| `subreddit_id` | integer |
| `name` | string |
| `…` |  |

## Task

Write a SQL query that returns subreddits with more than 3 subscribed users. Return the columns `subreddit_name` and `total_users`, ordered by `total_users` in descending order.

No community answers have been contributed yet. The page includes Question, Solution, and Community tabs; the solution is locked in the rendered interface. The code panel offers SQLite, Editor, Share, Output, Test Results, and Console views. Running code requires [signing up](https://www.aced.io/signup?src=lesson).

## Related question

- [Design Reddit.](https://www.aced.io/questions/1298/design-reddit)

Detailed company statistics 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%2F3079%2Freddit-users&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%2F3079%2Freddit-users). Opening a form does not execute a tool.