How much hands-on experience do you have with relational databases (e.g. PostgreSQL, SQL Server)?
To demonstrate practical experience, write a query against the provided contractor and payment tables. Return contractors with at least two completed payments during 2025 and completed payments totaling at least 1,000.
contractor_id, contractor_name, country, completed_payment_count, total_completed_amount, and latest_payment_date.total_completed_amount descending, then contractor_name ascending.| Column | Type | Description |
|---|---|---|
| contractor_idPK | INT | Unique contractor identifier |
| contractor_name | VARCHAR(100) | Contractor display name |
| country | VARCHAR(80) | Contractor country |
| start_date | DATE | Contract start date |
| status | VARCHAR(30) | Current contractor status |
| Column | Type | Description |
|---|---|---|
| payment_idPK | INT | Unique payment identifier |
| contractor_id | INT | Contractor receiving the payment |
| payment_date | DATE | Date of payment |
| amount | NUMERIC(12,2) | Payment amount |
| payment_status | VARCHAR(30) | Payment processing status |