Benchmarking Tool Report
Updated
Problem statement
A benchmarking tool stores each device's score in devices. Its columns are id, an integer primary key, and score, an integer.
Return one column named device. Each device gets one row in the exact format Device <id> has class: <letter>, with the spaces, capital letters and colon shown.
Awhen the score is at least 80.Bwhen the score is at least 60 and below 80.Cwhen the score is at least 40 and below 60.Dwhen the score is at least 20 and below 40.Fwhen the score is below 20.
Sort the result by numeric device ID in ascending order. Keep separate rows for devices with the same score.
For this exercise, assume every score is non-null. Device IDs are unique and cannot be null. An empty table produces no result rows.
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.
devices
| Column | Type | Nullable | Description |
|---|---|---|---|
| idPK | Integer | No | — |
| score | Integer | No | — |
Expected result
Your query or function must return these columns.
| Column | Type | Nullable | Description |
|---|---|---|---|
| device | Text | No | — |
Row order: must match exactly. Numeric tolerance: 0.
Constraints
devicescontains 0 to 200 rows.idandscoreare non-null signed 32-bit integers, from -2147483648 to 2147483647.idis the primary key.
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
- Freelance Candidate ReviewOA · Seen Nov 2023
- Count Fit Records Across PagesOA · Seen Sep 2023
- Network FormationOA · Seen Sep 2023
Similar questions at other companies
- Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
- Prepare Taxi Driver Classification DataBoston Consulting Group · OABoston Consulting Group interview questions
- Clean the TapeMillennium · OAMillennium interview questions
- Summarize Customer RecordsAgoda · OAAgoda interview questions
- Latest New JobSphere · ONSITE INTERVIEW
- Second Highest SalaryHartford Financial Services · ONSITE INTERVIEWHartford Financial Services interview questions
- In-Memory Database QueriesOpenAI · PHONE SCREEN · ONSITE INTERVIEWOpenAI interview questions
- Count User Mentions in Chat MessagesRamp · OARamp interview questions
- Catch Fish with Reusable BaitsSusquehanna International Group (SIG) · OASusquehanna International Group (SIG) interview questions
- Students Scoring Above AverageCapstone Investment Advisors · OA