Upstart Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Calculate Average Event Value by User ID
events +----+---------+------------+-------+---------------------+ | id | user_id | event_type | value | timestamp | +----+---------+-------...
Write monthly touches and last-touch SQL
You have two tables tracking marketing touches and downstream conversions. Write SQL to answer the three prompts below. Assume a warehouse like Postgr...
Manipulate data in R with dplyr joins and windows
Using R and dplyr, answer the following using these small tables (dates are ISO strings): transactions(user_id, order_id, order_date, channel, amount)...
Solve SQL CTR and Python analytics tasks
Part A — SQL: Compute click-through rate (CTR) by pin_format for US new users. New users are those whose signup_date is within 30 days (inclusive) of ...
Calculate User Revenue and Session Duration in Python
events +---------+------------+---------+---------------------+ | user_id | event_type | revenue | timestamp | +---------+------------+-----...