Posts With Heart Reactions

Facebook

Interview Core Track · Easy · 15 min

At Facebook, analysts are preparing a scorecard focused on posts with heart reactions. The engagement team wants the full post records for posts that receive...

Interview Core Track

Easy

15 min

joins

filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice joins through a Facebook-tagged business scenario.

Approach

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

At Facebook, analysts are preparing a scorecard focused on posts with heart reactions. The engagement team wants the full post records for posts that received at least one heart reaction. Return distinct rows from facebook_posts for matching posts.

facebook_posts

post_id INTEGER PRIMARY KEY

poster VARCHAR(100

facebook_reactions

reaction_id INTEGER PRIMARY KEY

poster VARCHAR(100

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.