SQL and product analytics. The SQL part is easy to prepare for, what you need to know very well is aggregation functions, join and union. The SQL questions are based on a real Facebook use cases. You get a table with all activities - id, activity type, typed content, user_id and cetra. What you need to do is to write code to calculate the number of reported abusive comments of some sort, and later to provide the percent of reported content per day which are actually abusive by combining another table.

Question

SQL and product analytics. The SQL part is easy to prepare for, what you need to know very well is aggregation functions,  join and union. The SQL questions are based on a real Facebook use cases. You get a table with all activities - id, activity type, typed content, user_id and cetra. What you need to do is to write code to calculate the number of reported abusive comments of some sort, and later to provide the percent of reported content per day which are actually abusive by combining another table.

Meta

Pergunta de entrevista da empresa Meta

Empresas seguidas

Buscas de vagas