Adobe·Data Scientist·Technical Phone Screen
- Write a SQL query to count the number of distinct daily active users.
- Write a SQL query to return the three most common event types from yesterday.
- Write a SQL query to list all users whose first recorded event was an install.
- Given a dictionary in Python, write code to invert it so that values become keys and keys become values.
- Remove duplicates from a Python list in a single line of code.
- Reverse a string in Python using a single line of code.
“Pretty bread and butter.”