Users With Zero Transactions This Month
Find verified users who have not made any completed transactions during March 2026. Return user_id, signup_date, and account_tier. Order by signup_date descending so newest users appear first.
15 SQL practice questions in our Coinbase 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.
5 Easy · 6 Medium · 4 Hard
Independent practice resource. Not affiliated with or endorsed by Coinbase.
These topics come from the questions in this set. Pick one to open the matching problems.
Find verified users who have not made any completed transactions during March 2026. Return user_id, signup_date, and account_tier. Order by signup_date descending so newest users appear first.
Calculate daily trading volume (sum of amount_usd for completed transactions) for each crypto asset, then compute a 7-day rolling average. Return transaction_date, crypto_asset, daily_volume, and rolling_avg_7day. Order by asset and date.
Identify the top 3 most profitable traders for each crypto asset in 2026. Net profit is calculated as (total sell volume - total buy volume - total fees). Return user_id, crypto_asset, net_profit, and profit_rank. Only include verified users with completed transactions.
15 Coinbase problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
user_id (INT) · signup_date (DATE) · kyc_status (VARCHAR) · account_tier (VARCHAR) · country (VARCHAR)
transaction_id (INT) · user_id (INT) · transaction_type (VARCHAR) · crypto_asset (VARCHAR) · amount_usd (FLOAT) · amount_crypto (FLOAT) · fee_usd (FLOAT) · transaction_date (TIMESTAMP) · status (VARCHAR)
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 Coinbase SQL free188 SQL practice questions. 23 companies. Free access to every problem.