The interviewer was a very energetic and friendly woman, and everything she asked me was about group calls. The premise: Messenger has groups, but no group call feature.
The first SQL question was pretty common, but the second one I'd never seen before.
What percentage of today's active "gb" users had more than 50 call records in the previous 7 days (counting both calls made and calls received)?
The first table was caller, receiver, call_id, date, duration. The second table was caller, country, is_active (0 or 1), date.
That's roughly what the question was — the exact details might be slightly different from what I remember.
The product sense questions were pretty standard: how to tell whether users actually have this need, how to decide on group size, how to measure success, how to avoid the problem where, using cluster-level data, a cluster is still internally connected (or the cluster ends up too large), and also A/B testing and trade-offs.
Addendum: the "caller" field in the second table might not be the name I actually saw — just think of it as "user." Also, one more detail: the date field is in string format.
Discussion
Loading comments…