Data Engineering Movie Success Pipeline

Requirements During the first 30 minutes, use SQL against movie and user data to assess how well a newly released movie is performing. Explain which tables and measurements you would require before writing the queries. Use standard SQL techniques such as GROUP BY, SUM, common table expressions, predicates, and joins. Discuss how the resulting pipeline would operate in production, including data validation, partitioning, skew management, scheduling, and recovery from…