SQL for Tenant Payment Analysis | Dataford Interview Questions

Write a basic SQL query structure to analyze tenant payment histories by status and month.

Use the tenant_payments table. Include records with a payment date, label missing payment statuses as Unknown, and exclude records without a payment date.

Output

One row per payment month and status.
Columns: payment_month, payment_status, and payment_count.
Sort by payment month ascending, then status ascending.

Schema

tenant_payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
tenant_id	INT	Identifier of the tenant associated with the payment
payment_date	DATE	Date on which the payment was recorded
payment_status	VARCHAR(30)	Payment processing status
amount	NUMERIC(10,2)	Payment amount

Your question is SQL for Tenant Payment Analysis. Start with the requirements and the one table 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