00:00

2259. Verified Users’ Posts in the Last 14 Days

MediumSQLITE96 / 1584

Relevant companies

2259. Verified Users’ Posts in the Last 14 Days

Medium96 / 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 Content Analyst at Twitter/X. The community management team wants to spotlight recent content from verified members for a featured creators program.

Your task is to provide a list of published posts from verified users in the last 14 days. Include the post details and sort by the most recent post time first.

Schema: posts

Column Name	Type
post_id	INTEGER
user_id	INTEGER
content_text	TEXT

Business Problem

You are a Content Analyst at Twitter/X. The community management team wants to spotlight recent content from verified members for a featured creators program.

Your task is to provide a list of published posts from verified users in the last 14 days. Include the post details and sort by the most recent post time first.

Schema: posts

Column Name	Type
post_id	INTEGER
user_id	INTEGER
content_text	TEXT

Verified Users’ Posts in the Last 14 Days — SQL Medium | Let's Data Science | Let's Data Science

post_id	user_id	created_at	visibility	status
15	4	2025-08-28 18:36:55	public	published
16	4	2025-08-21 00:56:41	public	published
14	3	2025-08-17 02:52:19	followers	published

post_id	user_id	created_at	visibility	status
15	4	2025-08-28 18:36:55	public	published
16	4	2025-08-21 00:56:41	public	published
14	3	2025-08-17 02:52:19	followers	published

Column Name	Type
user_id	INTEGER
username	TEXT
full_name	TEXT
email	TEXT
country	TEXT
join_date	TEXT

2259. Verified Users’ Posts in the Last 14 Days

Relevant companies

Tags

2259. Verified Users’ Posts in the Last 14 Days

Relevant companies

Tags

Sign in to Practice