In this video, we break down a common analytics-style SQL interview question involving running totals and revenue contribution.
We calculate seller-level revenue, total marketplace revenue, running cumulative revenue, and each seller’s percentage contribution to total revenue.
Topics covered:
• SQL Interview Preparation
• GROUP BY
• SUM()
• Window Functions
• SUM() OVER ()
• Running Totals
• Revenue Contribution Analysis
• CTEs
The goal is not just to memorize the query, but to understand the pattern behind the solution.
Code. Query. Crack.
