Apple Data Manipulation (SQL/Python) Interview Questions
Practice the exact questions companies are asking right now.
Detect 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...
Write 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...
Compute and Rank Store Revenue by Region Using Pandas
Sales +------------+---------+------------+--------+---------+ | date | store_id| product_id | units | revenue | +------------+---------+------...
Analyze TSV File for User Page Visits and Patterns
visits +-----------+-----------+------+ | person_id | timestamp | page | +-----------+-----------+------+ | 1 | 100 | A | | 1 ...
Explain Python lists, dicts, and concurrency
Explain the differences between Python lists and dictionaries (maps), including common operations and their average time complexity, iteration order g...