Meta
Interview Core Track · Easy · 15 min
Meta AR Filter Engagements
Which AR filters have generated user interactions in July 2024? List the filters by name.
Interview Core Track
Easy
15 min
joins
filtering
date functions
Company labels are directional practice context, not official interview guidance.
Timer 00:00
Objective
Practice joins through a Meta-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
Which AR filters have generated user interactions in July 2024? List the filters by name.
ar_filters
filter_id INTEGER
filter_name TEXT
ar_filter_engagements
engagement_id INTEGER
filter_id INTEGER
engagement_date DATE
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.