Average Post Hiatus
For each user who posted at least twice in 2024, find the number of days between their first post and last post of the year. Return user_id and days_between.
Tables: posts
SQL practice / Meta
Free SQL interview practice
Meta SQL interview questions. All free.
36 SQL practice questions in our Meta collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 1 Easy–Medium · 15 Medium · 7 Medium–Hard · 12 Hard
Independent practice resource. Not affiliated with or endorsed by Meta.
Inside the Meta set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
Joins 17 questionsCTEs 14 questionsWindow functions 14 questionsDates 10 questionsAggregation 9 questionsNULL handling 7 questionsConditional logic 6 questionsDedup 3 questionsUNION 1 question
App Click-Through Rate
Calculate the click-through rate (CTR) for each app in 2022. CTR = 100 * clicks / impressions, rounded to 2 decimal places. Output app_id and ctr.
Tables: events
MAU Retention
Find the count of users retained in July 2022 — users who were active in both July 2022 AND June 2022. Return retained_users as a single value.
Tables: user_actions
The bank
Meta SQL questions. Start typing SQL.
36 Meta problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Average Post HiatusDates, AggregationEasy5 minApp Click-Through RateConditional logic, NULL handlingEasy–Medium8 minAverage Shares per PostJoins, NULL handling, CTEsMedium10 minTwo Different Products Same DayAggregationMedium10 minPromotion EffectivenessCTEs, Dates, JoinsMedium12 minPercentage of Interactions by TypeWindow functions, Conditional logicMedium10 minNew vs. Existing Users by MonthCTEs, Conditional logicMedium12 min7-Day Rolling Average of SignupsWindow functions, CTEsMedium12 minUsers With 10+ Searches in SessionAggregationMedium10 minLikes on Friend's PostsJoins, UNIONMedium12 minCustomers Who Bought Two BrandsAggregationMedium10 minCurrent vs. Previous Month Post RateWindow functions, CTEs, DatesMedium12 minPractice Meta SQL — 36 questions
How it works
Solve in the browser. Checked instantly.
- 1Pick a problemPractice questions for data science and analytics interviews, each with its own tables, difficulty, and time target.
- 2Write and run SQLA full database engine loads in the tab. No setup, nothing to install — query the practice dataset immediately.
- 3Submit for a verdictPass and move to the next problem. Miss and you unlock the expected output and a reference solution.
Your dataset
posts
user_id (INTEGER) · post_id (INTEGER) · post_date (TIMESTAMP) · post_content (TEXT)
36
Meta questions
188
questions in the full bank
$0
free access
Solve one now. Build your solved history.
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Meta SQL freeExplore SQL questions by company.
188 SQL practice questions. 23 companies. Free access to every problem.