Back to problems

Group Video Call Data Analysis Queries

SQL · Meta · Medium

Problem You are given several tables describing group video calls, such as users, calls or sessions, session participants, and event logs. Using the schema and business definitions supplied by the interviewer, write SQL queries that generate the requested metrics and result tables. Your responses should also make the underlying definitions explicit. Address topics such as: What qualifies as a group video call. How duplicate records are removed. How repeated join and leave…

Checking your access…