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 data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
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