Apple Data Scientist Data Manipulation (SQL/Python) Interview Questions
Practice the exact questions companies are asking right now.
4Questions
1Company
4 Questions 1 Company
Showing 4 results
Apple
Medium
Data ScientistDetect sessions and gaps using SQL LEAD
Write a single ANSI-SQL query that (a) assigns per-user session_ids when the gap between consecutive events exceeds 30 minutes, (b) computes session_s...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Apple
Easy
Data ScientistWrite queries to compute salary and budget stats
You are given the following interview tasks. Write solutions in SQL and/or Python (pandas) as appropriate. Task 1 — Second highest salary You have a t...
Data Manipulation (SQL/Python)
0
0
Aug 24, 2025
Apple
Medium
Data ScientistCompute and Rank Store Revenue by Region Using Pandas
Sales +------------+---------+------------+--------+---------+ | date | store_id| product_id | units | revenue | +------------+---------+------...
Data Manipulation (SQL/Python)
0
0
Aug 4, 2025
Apple
Medium
Data ScientistAnalyze TSV File for User Page Visits and Patterns
visits +-----------+-----------+------+ | person_id | timestamp | page | +-----------+-----------+------+ | 1 | 100 | A | | 1 ...
Data Manipulation (SQL/Python)
0
0
Aug 4, 2025