Meta·Software Engineer·Technical Phone Screen
- Given a calls table with a pickup flag and call type, write a query returning the total number of calls and the number of picked-up calls broken down by call type.
- For a given country, compute the pickup rate (as a percentage) for calls placed by senders from that country. You need to join the calls table to a users table to get the sender's country.
- What percentage of distinct callers have made at least one video call AND at least one voice call? The denominator should be all distinct senders in the calls table.
“Pretty standard aggregation warmup.”