Write SQL and Python, run instantly in your browser, and track your progress.
You are a Content Strategist at Meta. The Product team needs to understand how content types are distributed across different visibility settings. Count posts grouped by both content_type and visibility.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_text | object |
| content_type | object |
You are a Content Strategist at Meta. The Product team needs to understand how content types are distributed across different visibility settings. Count posts grouped by both content_type and 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 |
| content_type | visibility | post_count |
|---|---|---|
| text | public | 39 |
| link | public | 32 |
| image | public | 25 |
| text | followers | 23 |
| video | public | 21 |
| content_type | visibility | post_count |
|---|---|---|
| text | public | 39 |
| link | public | 32 |
| image | public | 25 |
| text | followers | 23 |
| video | public | 21 |
Showing first 5 of 15 rows.
Showing first 5 of 15 rows.
1. Grouping:
2. Aggregation:
3. Output:
1. Grouping:
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 |