Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Analyst at Meta. The Content team wants to understand what types of content are being published on the platform. Filter posts to only those with 'published' status, then calculate content metrics by type.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
You are a Product Analyst at Meta. The Content team wants to understand what types of content are being published on the platform. Filter posts to only those with 'published' status, then calculate content metrics by type.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
| link_url | object |
| link_url | object |
| visibility | object |
| visibility | object |
| created_at | object |
| created_at | object |
| status | object |
| status | object |
| 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 |
| content_type | post_count | unique_authors |
|---|---|---|
| text | 56 | 39 |
| image | 36 | 30 |
| link | 35 | 28 |
| video | 32 | 24 |
| poll | 20 | 15 |
| content_type | post_count | unique_authors |
|---|---|---|
| text | 56 | 39 |
| image | 36 | 30 |
| link | 35 | 28 |
| video | 32 | 24 |
| poll | 20 | 15 |
5 rows returned.
5 rows returned.
1. Data Selection:
2. Aggregation:
3. Output:
1. Data Selection:
2. Aggregation:
3. Output:
| published |
| published |
| 2 | 1 | For everyone asking about technology... | link | https://example.com/41544 | public | 2025-04-20 09:23:49 | published |
| 2 | 1 | For everyone asking about technology... | 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 |