SQL for Transaction Thresholds | Dataford Interview Questions

Write a SQL query to find the monthly active users who performed more than three specific transactions in the last quarter.

Use users and transactions. For this exercise, qualifying transactions have a transaction_type of consultation or payment, and the last quarter means the previous completed calendar quarter relative to CURRENT_DATE.

Output

Return one row per qualifying user and calendar month.
Include activity_month, user_id, and transaction_count.
Include only users with more than three qualifying transactions in that month, ordered by activity_month and user_id.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
created_at	DATE	Date the user was created

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User associated with the transaction
transaction_type	VARCHAR(50)	Transaction classification
occurred_at	TIMESTAMP	Timestamp when the transaction occurred

Your question is SQL for Transaction Thresholds. 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