SQL Quest › SQL Interview Prep › Coinbase
Two data scientist reports from 2025 each describe two SQL questions on users and their trades — who is active in the last 30 days, 7-day retention, time from adoption to first transaction — with the interviewer pressing on how each metric is defined.
16 practice challenges · 5 Easy / 5 Medium / 6 Hard · your first 10 solves free · runs in the browser
What is sourced: Coinbase does not publish its interview format, so every specific about their process on this page is what candidates and prep guides described publicly — each one carries its source and the date it showed. Formats change; treat them as reported, not official. What is ours: the practice questions are SQL Quest challenges, picked because their SQL matches the patterns those sources report. They are not questions Coinbase has asked.
Coinbase does not publish the format. Each row is what candidates and prep guides have described publicly, with its source; where sources disagree, the row says so. Formats change — treat every specific as reported, not official.
| Roles where SQL is tested | Data Science, Analytics and Data Engineering.[5] |
|---|---|
| Overall process | A prep guide describes a 30-minute recruiter screen, a 30-minute online assessment for all candidates, a final round of four 60-minute interviews over Google Meet, then a work trial — a case on a dataset, presented to a panel.[1] |
| The SQL round | One senior data scientist report (interview March 2025) calls the SQL and data analysis round the most important: two questions written in CoderPad, on trades and sign-ups, with follow-ups on how retention should be defined.[2] |
| Onsite | Another data scientist report (interview October 2025) describes an onsite with a case study, two SQL questions — the second in three parts — and a live Python round of exploratory analysis and modelling on a dataset.[3] |
| Where sources differ | The guide describes the data science round as a conversation plus a whiteboard part; the March 2025 report names CoderPad. Neither report says whether the SQL was run. A second guide lists more rounds, including an AI-led behavioural screen for some 2025–2026 candidates.[1][2][4] |
Sources: Aced (formerly Exponent) — Coinbase interview process (shown as "last updated 2 months ago" on 20 Nov 2026); PracHub — Coinbase Senior Data Scientist interview experience (candidate report, interview Mar 2025) (25 Aug 2026); PracHub — Coinbase Data Scientist onsite (candidate report, interview Oct 2025) (25 Aug 2026); PracHub — Coinbase Data Scientist interview guide (updated 3 Nov 2026); DataLemur — Coinbase SQL interview questions (20 Feb 2025). Accessed 13 Sep 2026.
Reported most often, in order
Difficulty: Reported as medium by one candidate and hard by another; the medium report says the SQL itself was not especially hard and the interviewer weighed the reasoning. The data is crypto trades (user, asset, volume, time), sign-ups and first trades, and user transactions with an adoption time and a region.
Our Coinbase practice set, by skill
The 16 SQL Quest challenges tagged Coinbase, resolved onto the nine Skillmap skills. A challenge exercises several skills, so shares do not sum to 100%. This is the composition of the practice set on this page, not a measurement of Coinbase’s interview.
Shapes candidates and guides report (paraphrased)
Practise now — SQL Quest challenges matched to those patterns
Our challenges, chosen because their SQL matches the shapes above; not questions Coinbase has asked. Each card opens the challenge in the browser — no signup; a card marked Free can be one of your 10 free challenge solves.
These are SQL Quest challenges matched to the topics candidates report for Coinbase — not questions Coinbase has asked.
Every query here runs on SQLite in your browser. Joins, GROUP BY, CTEs and window functions are written the same way in PostgreSQL, MySQL and Snowflake; dates are where they differ (SQLite's strftime('%Y-%m', ts) is to_char(ts, 'YYYY-MM') in PostgreSQL), and the app lists each difference beside every challenge.
Drill the skills the Coinbase set leans on, one at a time: GROUP BY exercises · Window function practice · Date function practice · CTE practice · JOIN practice — or browse every SQL practice question.
Every question in the Coinbase set, one page each with the schema and a hint: Monthly Order Count · January 2024 Orders · Monthly Spend Per Account · Signup-Month Cohort Spend · The Ledger's First Week, Day by Day · Multi-Month Active Customers · Month-over-Month Customer Growth · Most Recent Order Per Customer (ROW_NUMBER) · The Previous Order's Total (LAG) · Running Total of Orders · Cumulative Distinct Customers Over Time · Daily Active Customers · Engagement Streaks (3+ Orders, ≤7-Day Gaps) · Month-over-Month Revenue Growth · Customer Retention Cohort · First-to-Second Transaction Latency.
Skillmap
Ten questions, no signup. You get a readiness score weighted to the SQL this page covers, your Skillmap across joins, window functions, aggregation and the rest, and the weakest skill to practise first.
No signup, no card. Your first 10 challenge solves are free; the Skillmap shows what to fix before the interview.
Start the Coinbase set — free