Point72 Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Convert Dates to Calendar Quarter Labels in SQL/Python
Transactions +----+-----------+ | id | trans_dt | +----+-----------+ | 1 | 20230115 | | 2 | 20230402 | | 3 | 20230930 | | 4 | 20231201 | +---...
List Departments with Student Counts Including Zero
Students +----+--------+---------+ | id | name | dept_id | +----+--------+---------+ | 1 | Alice | 1 | | 2 | Bob | 2 | | 3 | Caro...
Write SQL for top student per department
Schema: Departments(dept_id PK, dept_name) Students(student_id PK, student_name, dept_id FK nullable, gpa numeric(3,2) nullable, enrolled_at date) Sam...
Convert integer dates to quarters
Given an 8-digit integer date_key in YYYYMMDD (e.g., 20240331), write: (a) a SQL expression and (b) a Python function that convert it to a quarter lab...
Write SQL for recent customer activity
Write a single ANSI‑SQL query that produces, for every customer who has at least one non‑canceled order ever: (1) last_order_ts across all time consid...