Complex~36min
The One Customer
Revenue is up 16% year-over-year. The growth deck is ready. Before it goes to investors, someone on the finance team quietly asked: "What does the number look like if you strip out DIST-00041?"
Tables you'll query
customer_segmentscustomersordersproducts
What you'll learn
CTEs (WITH clause)Window FunctionsAggregations & GROUP BYCohort Analysis