Spot the Sale
You've been given two tables:
A table with promotional periods, each with a start and end date
A table with orders, each with an order date and quantity
Your task is to join each transaction to the promotion active on its order date.
Example:
Submit your solution
How many orders were placed outside of promotional periods?
Watch the solution video & tutorial
