00:00

2510. Published Posts from Verified Users (Normalized)

MediumSQLITE108 / 1584

Relevant companies

2510. Published Posts from Verified Users (Normalized)

Medium108 / 1584

Relevant companies

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a Data Analyst on the Trust & Safety team at X (formerly Twitter). You are building a dataset to train a machine learning model that identifies spammy behavior, even from verified accounts. Your initial hypothesis is that posts containing only a link, or only text, are more likely to be spam than posts containing both.

To build this dataset, you need to query all published posts from verified users in the last year that are visible to the public or followers. The query must create flags to indicate the presence of text and a link.

The final report should be sorted by the post date, newest first.

Schema: posts

Column Name

Business Problem

The final report should be sorted by the post date, newest first.

Schema: posts

Column Name

Published Posts from Verified Users (Normalized) — SQL Medium | Let's Data Science | Let's Data Science

post_id	INTEGER
user_id	INTEGER
content_text	TEXT
content_type	TEXT
link_url	TEXT
visibility	TEXT
created_at	TEXT
status	TEXT

post_id	INTEGER
user_id	INTEGER
content_text	TEXT
content_type	TEXT
link_url	TEXT
visibility	TEXT
created_at	TEXT
status	TEXT

Column Name	Type
user_id	INTEGER
username	TEXT
email	TEXT
is_verified	INTEGER
bio	TEXT

Column Name	Type
user_id	INTEGER
username	TEXT
email	TEXT
is_verified	INTEGER
bio	TEXT

post_id	user_id	is_verified	content_type_upper	visibility_upper	has_text	has_link	post_date
15	4	1	TEXT	PUBLIC	1	0	2025-08-28
16	4	1	IMAGE

2510. Published Posts from Verified Users (Normalized)

Relevant companies

Tags

2510. Published Posts from Verified Users (Normalized)

Relevant companies

Tags

Sign in to Practice