The Price is Right
Your dataset contains three tables from a pizza restaurant:
A transactions table with order date, product, and quantity
A products table with the current price for each product
A price history table with the price changes for each product over time
Your task is to look up the price for each product in the transactions table at that point in time, accurately reflecting the price changes.
NOTE: If the effective date of a price change is equal to the order date for a transaction, then that is the price that should be reflected.
See example below:
Submit your solution
What is the total revenue from the transactions? (round down to nearest integer)
Watch the solution video & tutorial
