SQL, Python, and ETL Proficiency | Dataford Interview Questions

What is your proficiency in SQL, Python, and ETL?

For the SQL portion, write a query that identifies Binance users with at least two filled spot trades during January 2025 and more than 1,000 USDT in total quote volume.

Output

Return one row per qualifying user with email, trade_count, total_quote_volume, and first_trade_at.
Order by total_quote_volume descending, then user_id ascending to break ties.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Binance user identifier
email	VARCHAR(255)	User email address
account_status	VARCHAR(20)	Current account status

trades

Column	Type	Description
trade_idPK	INT	Unique trade identifier
user_id	INT	User who executed the trade
market	VARCHAR(20)	Trading pair
market_type	VARCHAR(20)	Market category
executed_at	TIMESTAMP	Trade execution timestamp
quote_volume	DECIMAL(18,2)	Trade volume in the quote asset
status	VARCHAR(20)	Trade processing status

Your question is SQL, Python, and ETL Proficiency. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem