Write SQL and Python, run instantly in your browser, and track your progress.
You are a Content Strategist at Meta. The Engagement team is analyzing high-visibility content for a trends report. They need all posts that are either visual content (image or video) OR have public visibility. This captures content most likely to go viral.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
You are a Content Strategist at Meta. The Engagement team is analyzing high-visibility content for a trends report. They need all posts that are either visual content (image or video) OR have public visibility. This captures content most likely to go viral.
| 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 |
| post_id | user_id | content_type | visibility |
|---|---|---|---|
| 1 | 1 | video | followers |
| 2 | 1 | link | public |
| 3 | 1 | image | followers |
| 5 | 2 | image | followers |
| post_id | user_id | content_type | visibility |
|---|---|---|---|
| 1 | 1 | video | followers |
| 2 | 1 | link | public |
| 3 | 1 | image | followers |
| 5 | 2 | image | followers |
Showing first 5 of 171 rows.
Showing first 5 of 171 rows.
1. Data Selection:
2. Filtering:
3. Output:
1. Data Selection:
2. Filtering:
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 |
| 10 | 3 | link | public |
| 10 | 3 | link | public |