Employee Names With Access Records
Updated
Problem statement
Find employees who have used an access token at least once. The employees table has columns id and name. The access_logs table has columns employee_id and access_token.
Return one column named name. Include each employee whose ID has at least one matching access-log row, exactly once per employee. Several logs for the same employee do not add result rows. Different employees with the same name remain separate rows, so their name may appear more than once.
Return rows in any order. Employee IDs are unique and non-null. All names, log references and tokens are non-null, and every log refers to an existing employee.
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.
employees
| Column | Type | Nullable | Description |
|---|---|---|---|
| idPK | Integer | No | — |
| name | Text | No | — |
access_logs
| Column | Type | Nullable | Description |
|---|---|---|---|
| employee_id | Integer | No | — |
| access_token | Text | No | — |
Foreign key: employee_id → employees(id)
Expected result
Your query or function must return these columns.
| Column | Type | Nullable | Description |
|---|---|---|---|
| name | Text | No | — |
Row order: any order is accepted. Numeric tolerance: 0.
Constraints
employeeshas 0 to 200 rows andaccess_logshas 0 to 500 rows.- Employee IDs are signed
32-bit integers from -2147483648 to 2147483647. - Names have 1 to 60 ASCII letters or spaces. Tokens have 1 to 32 ASCII letters or digits.
- Repeated log rows and repeated tokens are allowed.
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
- Benchmarking Tool ReportOA · Seen Sep 2023
- Count Fit Records Across PagesOA · 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