Spot the Sale
Your Objective
Your Objective
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
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in AI, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER