SQL Query on Window Functions and Filtering, You have a table called UserActions with columns UserID, ActionDate, ActionType, and Duration (in seconds). Write a query to find the average duration of each action type (e.g., login, purchase) for each user over the past 6 months. Then, filter out any users whose average action duration for "login" actions is less than 30 seconds. Include the UserID, ActionType, and AverageDuration in your results.
Fiz uma entrevista na empresa Meta (Menlo Park, CA).
Entrevista
The Interview Process is very structured -
First Tech Screening round - 45 mins (usually can extend a bit depending on the interviewer)
- 2 SQL Questions ( Medium to Hard ) - based on Joins
Full Loop - 4 rounds 45 mins each.
- SQL
- Behavioral
- Analytical Execution - stats & prob, A/B testing, case study
- Analytical Reasoning - Case study
Perguntas de entrevista [1]
Pergunta 1
Questions on Bayes Theorem, Probability distribution, etc.
Candidatei-me online. O processo levou 6 meses. Fiz uma entrevista na empresa Meta.
Entrevista
Completed 3 rounds of the process, which includes the initial recruiter screen, technical, full loop, and team matching.
Couldn't move past the full loop interview. The interview was very engaging, and I actually enjoyed working through the cases. No crazy questions.
As melhores empresas na categoria “Remuneração e benefícios” perto de você