Complex~35min
The Happy Survey
NPS jumped from 34 to 73 after switching to a new survey tool in March. The product team is planning a case study. Engineering hasn't shipped anything major since February. Something changed — figure out what.
Tables you'll query
customerssurvey_sendsnps_responsessupport_tickets
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY