Freelance Candidate Review
Updated
Problem statement
Build a candidate review report from profiles and stats. Join profiles.id to stats.profile_id.
Keep only joined rows where is_verified = 1 and job_success_score >= 90. Return these columns in order: first_name, last_name, email, job_success_score.
Sort by score from highest to lowest, then by first name and last name from lowest to highest. Return the first ten rows, or all qualifying rows if fewer than ten exist.
For this exercise, assume text uses case-sensitive ASCII order. If the score and both names tie, sort by email in increasing ASCII order. Stats may contain several rows per profile, including identical rows; keep each qualifying joined row. A profile without a stats row does not appear.
Table schema
Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.
profiles
| Column | Type | Nullable | Description |
|---|---|---|---|
| idPK | Integer | No | — |
| first_name | Text | No | — |
| last_name | Text | No | — |
| Text | No | — | |
| is_verified | Integer | No | 1 means verified; 0 means unverified. |
stats
| Column | Type | Nullable | Description |
|---|---|---|---|
| profile_id | Integer | No | — |
| job_success_score | Integer | No | — |
Foreign key: profile_id → profiles(id)
Expected result
Your query or function must return these columns.
| Column | Type | Nullable | Description |
|---|---|---|---|
| first_name | Text | No | — |
| last_name | Text | No | — |
| Text | No | — | |
| job_success_score | Integer | No | — |
Row order: must match exactly. Numeric tolerance: 0.
Constraints
- For this exercise, assume
0to500profile rows and0to1000stats rows. - Profile IDs are distinct integers in
[1, 30000]. Every stats profile ID refers to a profile. is_verifiedis0or1, and every score is an integer in[0, 100].- For this exercise, assume every field is non-null and every text field contains
1to255printable ASCII characters, including spaces when present.
More Palantir Online Assessment questions
- Basic Item DiscountsOA · Seen Nov 2026
- Optimize Discount Selection Under a Point BudgetOA · Seen Nov 2026
- Stacked Item and Category DiscountsOA · Seen Nov 2026
- Minimize Path ValueOA · Seen Sep 2024
- No Pairs AllowedOA · Seen Sep 2024
- REST API: Country CodesOA · Seen Feb 2024
- Swap ParityOA · Seen Feb 2024
- Benchmarking Tool ReportOA · Seen Sep 2023
- Count Fit Records Across PagesOA · Seen Sep 2023
- Network FormationOA · Seen Sep 2023
Similar questions at other companies
- Students Scoring Above AverageCapstone Investment Advisors · OA
- Bond Interest Summary Above 3%Wells Fargo · OAWells Fargo interview questions
- Employee Promotion OpportunitiesIntuit · OAIntuit interview questions
- Students and Their SubjectsBirla Pivot · OA
- Companies with Average Salary Above 40000AT&T · OAAT&T interview questions
- Build Taxi Driver Performance FeaturesBoston Consulting Group · OABoston Consulting Group interview questions
- Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
- Companies Above a Salary ThresholdVerisk · OA
- Customer Resource Usage AnalysisIBM · OAIBM interview questions
- Customers Who Never OrderedAccenture · OAAccenture interview questions
Interview reports that mention this question
Palantir interview experiences
- Palantir FDSE Experienced-Hire Interviews: 5 Experiences
- Palantir FDSE New Grad OA Questions: 6 Experiences (Part 2 of 2)
- Palantir FDSE New Grad Interviews: 5 Experiences (Part 1 of 2)
- Palantir FDSE Karat and Learning: 7 Experiences (Part 2 of 2)
- Palantir FDSE OA and Interviews: 16 Experiences (Part 1 of 2)