FastPrepFreelance Candidate Review
Problems/Freelance Candidate Review

Freelance Candidate Review

Palantir logoPalantir● EasyINTERNOA

Updated Nov 2026

QuestionConstraints

Problem statement

Source note: Reported in a Palantir intern online assessment. The photos in the report show both table schemas, the filters for verified only and a score of at least 90, the sorting by score and name, the limit of ten rows, and the full sample.

We chose these rules: fields are never null and use printable ASCII, we set number and table limits, sorting is case-sensitive, repeated stats rows are kept, and the final tie-breaker is the email.

Our version is about 95% the same as the reported question.

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

MySQLPostgreSQLPandas

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

ColumnTypeNullableDescription
idPKIntegerNo—
first_nameTextNo—
last_nameTextNo—
emailTextNo—
is_verifiedIntegerNo1 means verified; 0 means unverified.

stats

ColumnTypeNullableDescription
profile_idIntegerNo—
job_success_scoreIntegerNo—

Foreign key: profile_id → profiles(id)

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
first_nameTextNo—
last_nameTextNo—
emailTextNo—
job_success_scoreIntegerNo—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

  • For this exercise, assume 0 to 500 profile rows and 0 to 1000 stats rows.
  • Profile IDs are distinct integers in [1, 30000]. Every stats profile ID refers to a profile.
  • is_verified is 0 or 1, and every score is an integer in [0, 100].
  • For this exercise, assume every field is non-null and every text field contains 1 to 255 printable 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 FDSE Intern OA and Interviews: 3 Experiences

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)
All Palantir interview questionsSee Palantir hiring insights