SQL: Group Video Call Data Analysis Queries

You are given several tables related to "group video calls" (e.g., users, calls/sessions, session participants, event logs). Solve several SQL query questions: Write SQL to produce the required metrics or result tables based on the specified business definitions. Clearly explain your logic and definitions (e.g., how you define a group video call, de-duplication rules, handling multiple join/leave events by the same user, daily/weekly aggregations). Requirements Be able to explain join relationships, filters, aggregation logic, and edge cases. Note: The original post does not provide exact schemas/details; follow the interviewer-provided schema.