SQL and Programming Interview Mix | Dataford Interview Questions

How would you approach a round that mixes SQL questions, programming, and a behavioral interview?

For the SQL portion, write a PostgreSQL query that summarizes completed transaction activity for every user.

Output

One row per user, including users with no transactions
Columns: user_id, email, completed_transaction_count, completed_transaction_total, and activity_status
Include only transactions whose status is completed; treat missing totals as zero
Order by total descending, then user_id ascending

users

Column	Type	Description
user_idPK	INT	Unique user identifier
email	VARCHAR(255)	User email address

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User associated with the transaction
status	VARCHAR(30)	Transaction processing status
amount	DECIMAL(12,2)	Transaction amount

Your question is SQL and Programming Interview Mix. 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.