Socure needs to inspect completed Socure ID+ verification records in descending risk-score order. Write a PostgreSQL query that returns the single record ranked tenth among eligible verifications.
verification_records to applicants to include the applicant name.decision_status = 'completed' and product_surface = 'Socure ID+'.risk_score descending, using verification_id ascending as a deterministic tie-breaker, then return rank 10.| Column | Type | Description |
|---|---|---|
| applicant_idPK | INT | Unique applicant identifier |
| full_name | VARCHAR(100) | Applicant's full name |
| Column | Type | Description |
|---|---|---|
| verification_idPK | INT | Unique verification record identifier |
| applicant_id | INT | References applicants.applicant_id |
| product_surface | VARCHAR(50) | Socure product or integration surface |
| decision_status | VARCHAR(30) | Current verification decision status |
| risk_score | INT | Risk score used for descending ranking |