Meta practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Meta
Explore 17 Meta-tagged SQL scenarios focused on query basics, aggregation, date functions.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
17
Estimated prep time
355 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Meta-tagged set.
Query basics
16
Aggregation
6
Date functions
4
Joins
3
Filtering
2
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Interest Pages Without Followers
Practice query basics through a Meta-tagged business scenario.
Third Customer Transaction
Practice query basics through a Meta-tagged business scenario.
2024 App Click Volume
Practice query basics through a Meta-tagged business scenario.
Question list
The current Meta-tagged list with learning objectives and your latest status.
Interest Pages Without Followers
The community team wants the page_id values for interest pages that never picked up a follower. Return the page IDs in ascending order.
Practice query basics through a Meta-tagged business scenario.
Third Customer Transaction
Meta wants a scorecard for third customer transaction. Return each user_id and transaction_date for the third transaction made by that user. Sort by user_id.
Practice query basics through a Meta-tagged business scenario.
2024 App Click Volume
Use this Meta quality audit to work on 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Practice query basics through a Meta-tagged business scenario.
Creators With Multiple 2024 Posts
Meta wants a quality audit for creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a Meta-tagged business scenario.
Top Product By Category
Meta wants a portfolio scan for top product by category. Return the highest-grossing product_id in each category during June 2024 along with category and tot...
Practice query basics through a Meta-tagged business scenario.
Departments Above Average Pay
Use this Meta planning note to work on departments above average pay. Return each department_id whose average salary exceeds the company average salary for M...
Practice query basics through a Meta-tagged business scenario.
Frequent Support Callers
Meta is reviewing frequent support callers through a monthly brief. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort b...
Practice query basics through a Meta-tagged business scenario.
Meta AR Filter Engagements
Which AR filters have generated user interactions in July 2024? List the filters by name.
Practice joins through a Meta-tagged business scenario.
Severity-One Resolution Pace
Reliability engineering wants to compare how quickly teams resolve the most urgent incidents. Return team_name, critical_incidents, and avg_resolution_hours ...
Practice query basics through a Meta-tagged business scenario.
Final Account Balance
At Meta, analysts are preparing a scorecard focused on final account balance. Calculate the final balance per account_id. Credits add to the balance and debi...
Practice query basics through a Meta-tagged business scenario.
Bidirectional Transfer Pairs
Use this Meta scorecard to work on bidirectional transfer pairs. Count unique transfer relationships regardless of direction. Return relationship_count.
Practice query basics through a Meta-tagged business scenario.
Tax Product Filing Mix
Use this Meta scorecard to work on tax product filing mix. The total number of TurboTax filings and QuickBooks filings. Return turbotax_total and quickbooks_...
Practice query basics through a Meta-tagged business scenario.
Rapid Repeat Payment Alerts
Meta is reviewing rapid repeat payment alerts through a scorecard. Count how many repeated payments happened within 10 minutes for the same merchant_id, cred...
Practice query basics through a Meta-tagged business scenario.
May Orders By Region
Use this Meta scorecard to work on may orders by region. Return each region and the number of orders placed during May 2024. Sort by region.
Practice query basics through a Meta-tagged business scenario.
Laptop Vs. Mobile Viewership (2)
At Meta, analysts are preparing a operations review focused on laptop vs. mobile viewership (2). Count how many views came from laptop devices and how many c...
Practice query basics through a Meta-tagged business scenario.
Second-highest Salary
Use this Meta ops memo to work on second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a Meta-tagged business scenario.
Monthly Reactivated Users
Meta wants a scorecard for monthly reactivated users. Count how many users logged in during a month after being inactive in the previous month. Return login_...
Practice query basics through a Meta-tagged business scenario.