Your question is SQL Ranking Query. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |