Meta·Data Scientist·Technical Phone Screen
- Using a calls table and a user profile table, write a query to find what percentage of French users participated in at least one video call the previous day.
- Write a query to calculate total video call duration divided by the number of daily active users in the United States for today.
“The join is straightforward but I tripped up on the DISTINCT count part.”