Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Analyst at LinkedIn. The Content team wants to understand how different content types are distributed across visibility settings. Create a pivot table showing the count of published posts by content type and visibility. Filter to only include posts with status 'published'.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_type | object |
| visibility |
You are a Product Analyst at LinkedIn. The Content team wants to understand how different content types are distributed across visibility settings. Create a pivot table showing the count of published posts by content type and visibility. Filter to only include posts with status 'published'.
| Column Name | Type |
|---|---|
| post_id | int64 |
| user_id | int64 |
| content_type | object |
| visibility |
| object |
| object |
| status | object |
| status | object |
| post_id | user_id | content_type | visibility | status |
|---|---|---|---|---|
| 1 | 101 | text | public | published |
| 2 | 102 | image | public | published |
| post_id | user_id | content_type | visibility | status |
|---|---|---|---|---|
| 1 | 101 | text | public | published |
| 2 | 102 | image | public | published |
| content_type | followers | private | public |
|---|---|---|---|
| image | 13 | 4 | 19 |
| link | 8 | 4 | 23 |
| poll | 8 | 3 | 9 |
| text | 17 | 6 | 33 |
| content_type | followers | private | public |
|---|---|---|---|
| image | 13 | 4 | 19 |
| link | 8 | 4 | 23 |
| poll | 8 | 3 | 9 |
| text | 17 | 6 | 33 |
5 rows returned.
5 rows returned.
1. Data Selection:
2. Reshaping:
3. Output:
1. Data Selection:
2. Reshaping:
3. Output:
| 3 |
| 3 |
| 103 |
| 103 |
| text |
| text |
| followers |
| followers |
| published |
| published |
| 4 | 104 | video | public | published |
| 4 | 104 | video | public | published |
| 5 | 105 | text | public | deleted |
| 5 | 105 | text | public | deleted |
| 6 | 106 | image | followers | published |
| 6 | 106 | image | followers | published |
| 7 | 107 | link | private | published |
| 7 | 107 | link | private | published |
| video | 15 | 1 | 16 |
| video | 15 | 1 | 16 |