Complex~36min
The Invisible Promotion
The Q2 email campaign is being celebrated as a success — orders up 34%. Marketing wants to double the budget. Before you do: 89% of the "converts" had already ordered in the 30 days before the email went out.
Tables you'll query
campaignsusersemail_sendsorders
What you'll learn
CTEs (WITH clause)Window FunctionsDate & Time FunctionsAggregations & GROUP BY