Google·Data Scientist·Technical Phone Screen
- Design a relational database schema for a video streaming company. What tables would you create, what are the key columns, and how do the tables relate to each other?
- Given a transactions table with user, order, and product columns, write a SQL query to find the pair of products most frequently bought together in the same order.
- Using Python and Pandas, how would you add a new column to a DataFrame where the values are derived from conditions applied to existing columns?
“I went with the usual suspects: users, content, subscriptions, watch history, maybe a separate table for genres or tags.”