Write SQL and Python, run instantly in your browser, and track your progress.
You are a data analyst on the Trust & Safety team at Reddit. The team is analyzing the types of external content being shared across the platform to identify trends and potential policy violations.
Your first task is to pull a raw feed of all posts that are specifically designed to share an external link, are publicly visible, and have been successfully published. This feed will be used as the basis for further analysis.
Please query the posts table and retrieve the post ID, user ID, content type, visibility, and creation time for all relevant posts. The list should be ordered with the most recently created posts appearing first.
| Column Name | Type |
|---|---|
| post_id | INTEGER |
| user_id |
You are a data analyst on the Trust & Safety team at Reddit. The team is analyzing the types of external content being shared across the platform to identify trends and potential policy violations.
Your first task is to pull a raw feed of all posts that are specifically designed to share an external link, are publicly visible, and have been successfully published. This feed will be used as the basis for further analysis.
Please query the posts table and retrieve the post ID, user ID, content type, visibility, and creation time for all relevant posts. The list should be ordered with the most recently created posts appearing first.
| Column Name | Type |
|---|---|
| post_id | INTEGER |
| user_id |
| INTEGER |
| INTEGER |
| content_text | TEXT |
| content_text | TEXT |
| content_type | TEXT |
| content_type | TEXT |
| link_url | TEXT |
| link_url | TEXT |
| visibility | TEXT |
| visibility | TEXT |
| created_at | TEXT |
| created_at | TEXT |
| status | TEXT |
| status | TEXT |
| post_id | user_id | content_text | content_type | link_url | visibility | created_at | status |
|---|---|---|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | followers | 2025-05-28 17:39:24 |
| post_id | user_id | content_text | content_type | link_url | visibility | created_at | status |
|---|---|---|---|---|---|---|---|
| 1 | 1 | Answering your questions about entrepreneurship | video | followers | 2025-05-28 17:39:24 |
| post_id | user_id | content_type | visibility | created_at |
|---|---|---|---|---|
| 136 | 32 | link | public | 2025-08-23 20:25:55 |
| 143 | 35 | link | public | 2025-08-14 12:29:27 |
| 214 | 56 | link | public | 2025-08-03 10:17:25 |
| post_id | user_id | content_type | visibility | created_at |
|---|---|---|---|---|
| 136 | 32 | link | public | 2025-08-23 20:25:55 |
| 143 | 35 | link | public | 2025-08-14 12:29:27 |
| 214 | 56 | link | public | 2025-08-03 10:17:25 |
Showing first 5 of 23 rows. These are public link posts ordered by most recent.
Showing first 5 of 23 rows. These are public link posts ordered by most recent.
Your final output should be a result set that meets the following requirements:
1. Filtering:
status of 'published'.visibility of 'public'.content_type is 'link'.2. Columns:
post_iduser_idYour final output should be a result set that meets the following requirements:
1. Filtering:
status of 'published'.visibility of 'public'.content_type is 'link'.2. Columns:
post_iduser_id| published |
| published |
| 2 | 1 | For everyone asking about technology here's a helpful resource | link | https://example.com/41544 | public | 2025-04-20 09:23:49 | published |
| 2 | 1 | For everyone asking about technology here's a helpful resource | link | https://example.com/41544 | public | 2025-04-20 09:23:49 | published |
| 3 | 1 | Sunset vibes from Austin | image | followers | 2025-06-02 01:35:31 | published |
| 3 | 1 | Sunset vibes from Austin | image | followers | 2025-06-02 01:35:31 | published |
| 4 | 2 | What's your take on web development? | poll | followers | 2025-07-19 11:27:33 | published |
| 4 | 2 | What's your take on web development? | poll | followers | 2025-07-19 11:27:33 | published |
| 5 | 2 | Morning coffee and good vibes | image | followers | 2025-08-04 14:31:30 | hidden |
| 5 | 2 | Morning coffee and good vibes | image | followers | 2025-08-04 14:31:30 | hidden |
| 121 | 28 | link | public | 2025-07-31 11:01:00 |
| 121 | 28 | link | public | 2025-07-31 11:01:00 |
| 158 | 38 | link | public | 2025-07-30 00:41:16 |
| 158 | 38 | link | public | 2025-07-30 00:41:16 |
content_typecontent_typevisibilityvisibilitycreated_atcreated_at3. Ordering:
3. Ordering:
created_at in descending order (newest first).post_id in ascending order.created_at in descending order (newest first).post_id in ascending order.