SQL Quest › SQL Interview Prep › Coinbase

Coinbase SQL Interview Questions

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.

Start the Coinbase set — free Check my readiness

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.

How the interview runs (sourced)

The Coinbase SQL interview, as candidates report it

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 testedData Science, Analytics and Data Engineering.[5]
Overall processA 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 roundOne 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]
OnsiteAnother 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 differThe 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]
  1. [1] Aced (formerly Exponent) — Coinbase interview process (shown as "last updated 2 months ago" on 20 Nov 2026)
  2. [2] PracHub — Coinbase Senior Data Scientist interview experience (candidate report, interview Mar 2025) (25 Aug 2026)
  3. [3] PracHub — Coinbase Data Scientist onsite (candidate report, interview Oct 2025) (25 Aug 2026)
  4. [4] PracHub — Coinbase Data Scientist interview guide (updated 3 Nov 2026)
  5. [5] DataLemur — Coinbase SQL interview questions (20 Feb 2025)

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.

The SQL that comes up

What Coinbase SQL questions test

Reported most often, in order

  • 1Time-window filters (the last 30 days)
  • 2COUNT DISTINCT and choosing the denominator
  • 3Retention and cohort timing (7-day retention)
  • 4Rates (adoption, transaction rate)
  • 5Time between events (adoption to first transaction)
  • 6First event per user, compared with later rows
  • 7Running and cumulative sums
  • 8Layered CTEs and window functions

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.

Sample questions

Coinbase SQL question shapes, and where to practise them

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.

Open all 16 Coinbase practice challenges →
Topic practice

Every challenge in the Coinbase set, by topic

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

How ready are you for the Coinbase SQL round?

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.

Check my Coinbase readiness Start the Coinbase set

Frequently asked

Ready for the Coinbase SQL round?

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