Write SQL and Python, run instantly in your browser, and track your progress.
You are a Content Analyst at Meta. The Insights team needs to analyze posts that are visible to the public for a trending content report. Filter the posts DataFrame to find all posts with 'public' visibility.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
You are a Content Analyst at Meta. The Insights team needs to analyze posts that are visible to the public for a trending content report. Filter the posts DataFrame to find all posts with 'public' visibility.
| 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 |
|---|---|---|---|
| 230 | 60 | text | public |
| 229 | 59 | link | public |
| 226 | 59 | image | public |
| 225 | 58 | video | public |
| post_id | user_id | content_type | visibility |
|---|---|---|---|
| 230 | 60 | text | public |
| 229 | 59 | link | public |
| 226 | 59 | image | public |
| 225 | 58 | video | public |
Showing first 5 of 127 rows.
Showing first 5 of 127 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 |
| 222 | 57 | link | public |
| 222 | 57 | link | public |