Pergunta de entrevista da empresa Meta
2 SQL, 2 coding and 1 product related question. SQL ) There is a messages table showing the messages sent and date information. Find the top 10 users that sent the most messages. Then again the same question but filter the users to the most active users (active after a certain date) Coding) There is a live stream of incoming data. How would you calculate the mean dynamically. How would you calculate the standard deviation. Product) A new feature is going to be implemented in Messenger app, how would you go about it?
Resposta da entrevista
Sigiloso
9 de mar. de 2019
SQL Question: select user_id,count(*) num_of_messages from messages where user_id in (select distinct user_id from messages where date>= ) group by user_id order by count(*) desc limit 10